OT: Derby to Oracle

Mike Seda <[email protected]> Wed, 15 Apr 2009 18:59:48 -0400

Newsgroups	gmane.org.user-groups.trijug.juglist
Message-ID	<[email protected]>

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