SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert trigger for primary key

239246Jun 14 2003 — edited Jun 23 2003

Hi all,
I am newby to PLSQL, I have a table "table1" with primary key typed number "table1.pk".
I would like my primary key to increase by 1 for every new record. How could I implement a insert trigger to do so?
Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 21 2003

Added on Jun 14 2003

15 comments

2,833 views