db-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Default table
Date Fri, 26 Oct 2007 02:10:20 GMT
> 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


Mime
View raw message