Re: OT: Derby to Oracle

I have also seen the sequence incremented automatically and set on a insert
using a Oracle Trigger.

On Thu, Apr 16, 2009 at 4:16 PM, Chris Bredesen <[email protected]>wrote:

> Probably what's failing you is the IDENTITY stuff.  Oracle doesn't have
> autonumber/identity so you'll have to create a sequence and set the default
> value of the ID column to sequence.nextval.
>
> Also, replace VARCHAR with VARCHAR2.
>
> -CB
>
>
> Mike Seda wrote:
>
>> All,
>> Does anyone know how to port the following SQL statement (that currently
>> works in Apache Derby) to Oracle:
>> CREATE TABLE SOMEDATABASE.SOMETABLE (
>> ID BIGINT GENERATED BY DEFAULT AS IDENTITY,
>> HEADER VARCHAR(255) NOT NULL ,
>> LINKTEXT VARCHAR(255) NOT NULL ,
>> URL VARCHAR(255) NOT NULL ,
>> DESCRIPTION VARCHAR(255) NOT NULL ,
>> DUEDATE DATE
>> );
>>
>> Mike
>>
>> _______________________________________________
>> Juglist mailing list
>> [email protected]
>> http://trijug.org/mailman/listinfo/juglist_trijug.org
>>
>
> _______________________________________________
> Juglist mailing list
> [email protected]
> http://trijug.org/mailman/listinfo/juglist_trijug.org
>



-- 
Mike Jennings

_______________________________________________
Juglist mailing list
[email protected]
http://trijug.org/mailman/listinfo/juglist_trijug.org