Re: Derby & Oracle.



Mr. X. wrote:
What is the equivalent for Derby, that is in oracle.

1. Select 1 from dual.

SELECT 1 FROM SYSIBM.SYSDUMMY1

(yes - the IBM roots can be seen)

2. How can I create sequences ?

Derby uses identity columns like SQLServer and MySQL
not sequences like Oracle.

Arne
.