Re: Default table

[Bryan Pendleton]

What is the default table name in Derby? I want to display some fixed data using SQL like

select '10' as digit
It runs in SQL server. In Oracle I can write in this way
select '10' as digit from dual
but here none of these are working. How can I solve this problem?

Here's two ways:

1) Use the "VALUES" statement:

 values cast ('10' as int);

2) Use SYSIBM.SYSDUMMY1 in place of DUAL:

 select cast('10' as int) from sysibm.sysdummy1;

thanks,

bryan