Re: Derby to Oracle

Hi Mike, 
I seem to remember from when I used Hibernate that Oracle uses sequences for auto-generating keys and the instructions at http://troels.arvin.dk/db/rdbms seem to confirm that. Hope this helps.
- jatin

> From: [email protected]
> Subject: Juglist Digest, Vol 43, Issue 4
> To: [email protected]
> Date: Thu, 16 Apr 2009 12:00:01 -0700
> 
> Send Juglist mailing list submissions to
> 	[email protected]
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://trijug.org/mailman/listinfo/juglist_trijug.org
> or, via email, send a message with subject or body 'help' to
> 	[email protected]
> 
> You can reach the person managing the list at
> 	[email protected]
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Juglist digest..."
> 
> 
> Today's Topics:
> 
>    1. OT: Derby to Oracle (Mike Seda)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 15 Apr 2009 18:59:48 -0400
> From: Mike Seda <[email protected]>
> Subject: [Juglist] OT: Derby to Oracle
> To: [email protected]
> Message-ID: <[email protected]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> 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
> 
> 
> End of Juglist Digest, Vol 43, Issue 4
> **************************************

_________________________________________________________________
Rediscover Hotmail®: Get e-mail storage that grows with you. 
http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Storage2_042009

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