Oracle - Create an autonumber field
Sunday, January 6th, 2008If you want to create an autoincrements field in a table, using Oracle, you may do this by using sequences. What are sequences? Well, sequence is a command that gives to you the power to do this. Nothing better than an example: create table user ( id number(10), name varchar2(32), primary key(id) ); If you want the id field increase automatically, you use the sequence: create sequence user_seq start with 1 increment ...
