Before anything, i want to say that this article was posted on my personal blog, and i only put it here because the chances that this article possible be useful for anyone are greater with HubPages.

Now, take a look:

If 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 by 1

nomaxvalue;

Naturally, as you can see, when new records are entry on table, the id field will be increasing.

insert into user values(user_seq.nextval, 'andre');

select * from user

... Experiment yourself now :)

Just for curiosity, the sintaxe of sequence is:

CREATE SEQUENCE sequence_name

    MINVALUE value

    MAXVALUE value

    START WITH value

    INCREMENT BY value

    CACHE value;

This post is on my personal blog too, in portuguese languange, here.