-
Auto Incrementing?
I'm trying to move from postgre to oracle 9i eventually so I need a little help converting stuff. Is there a way to create a table column to be auto incrementing by just setting the column type and then oracle will create the sequences on it's own?
In PostgeSQL I can simply write...
create table test(id SERIAL, primary key(id));
and that will create the sequences for the id column and make sure it is a primary key.
How would I do so in Oracle?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|