Thanks a lot... This is really helpful..
> 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 ;