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?