how implement auto_increament in oracle?

Answer 1

If you want to make your PK auto increment, you need to set the ID column property for that primary key.

Right click on the table and select "Edit".

In "Edit" Table window, select "columns", and then select your PK column.

Go to ID Column tab and select Column Sequence as Type. This will create a trigger and a sequence, and associate the sequence to primary key.

If you want to make your PK auto increment, you need to set the ID column property for that primary key.

Right click on the table and select "Edit".

In "Edit" Table window, select "columns", and then select your PK column.

Go to ID Column tab and select Column Sequence as Type. This will create a trigger and a sequence, and associate the sequence to primary key.

// My source is:

http://techatplay.wordpress.com/2013/11/22/oracle-sql-developer-create-auto-incrementing-primary-key/