How to make autoincrement in oracle?

[nikon]

I am finding trouble to find auto incement with the oracle table I am able to do it in mysql how can I implement it in oracle?

[valendino]

You can create sequence for the auto increment values in the oracle

create sequence sequencename

Let me know if you have problem further

[nikon]

I am new to oracle database so can you show me an example how to make a sequence?

[valendino]

First create table with numeric field in it

Then create sequence

create sequence myseq start with 1 increment by 1;

then create trigger

create or replace trigger mytrig
before insert on table
for each row
begin
    select myseq.nextval into :new.id from dual;
end;