Derby & Oracle.

Thread view:

Mr. X. - 14 Mar 2008 05:14 GMT

Hello,

What is the equivalent for Derby, that is in oracle.

1. Select 1 from dual.
2. How can I create sequences ?

Thanks :)

Reply to this Message

Arne Vajhøj - 14 Mar 2008 23:44 GMT

> 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

Reply to this Message

Mr. X. - 16 Mar 2008 11:21 GMT

For you answers :
1. Thanks.
2. I am looking for an alternative that is much like sequence
(table + some scripts ...), please.

Thanks :o)

Reply to this Message

Arne Vajhøj - 16 Mar 2008 16:51 GMT

> For you answers :
> 1. Thanks.
> 2. I am looking for an alternative that is much like sequence
> (table + some scripts ...), please.

Create a table mysequence with one column that are marked as identity.

Arne

Reply to this Message

Donkey Hot - 20 Mar 2008 19:52 GMT

Arne Vajhøj <arne@vajhoej.dk> wrote in news:47dd41b2$0$90265$14726298
@news.sunsite.dk:

>> For you answers :
>> 1. Thanks.
[quoted text clipped - 4 lines]
>
> Arne

There will not be NEXTVALUE or CURRENTVALUE, or will there?

Reply to this Message

Arne Vajhøj - 21 Mar 2008 00:41 GMT

> Arne Vajhøj <arne@vajhoej.dk> wrote in news:47dd41b2$0$90265$14726298
> @news.sunsite.dk:
[quoted text clipped - 5 lines]
>
> There will not be NEXTVALUE or CURRENTVALUE, or will there?

You INSERT in that table and use IDENTITY_VAL_LOCAL().

Arne

Reply to this Message

Derby & Oracle.

Free Magazines