Thanks a lot... This is really helpful..
Regards,
Soumen
On 10/25/07, Bryan Pendleton <[EMAIL PROTECTED]> wrote:
>
> > 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
>
