Thread: how to create an auto-increment process? - Oracle

sorry dear the statment auto_increment is not valid in oracle , so it is not it oracle but in postgre sql .Restall u can aany way define in oracle.

hello... i have a little problem about how to create an auto-increment process. i'm using an oracle and all the table and data is already exist in my database. I have seen a few example from internet and it is like this. table users { id int(13) not null auto_increment, name varchar( 45 ) not null default '', email varchar( 55 ) not null default '', website varchar( 100 ) not null default '', primary key( id...

It's definately Oracle. The first statement there is not actually valid, it's just describing the existing table for you The next one creates an incrementing sequence, however I would never use a trigger to implement it as you can't find out what the value of the sequence is without requerying the table. Then you have to rely on the line being easily identifiable without having it's primary key, pretty ugly. Create the...

Just get rid of "auto_increment". I think it'll work with int(13), if not, just use NUMBER.