0

how implement auto_increament in oracle?

17th Dec 2016, 6:45 PM
Aqib Asmat
Aqib Asmat - avatar
1 Odpowiedź
+ 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/
18th Dec 2016, 1:11 PM
Root