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!

?Trigger to return primary key value after insert"

157476Jan 7 2002 — edited Mar 5 2003

Ok, so I'm a newbie to oracle. I was hoping someone could tell
me how I can get the value of a field after insertion. I
created a sequence and a trigger to autoincrement the primary
key. I figured out that select @@Identity does not work. So
I'm trying to figure out how to return the primary key value of
just inserted record.

Any help or suggestions would be really appreciated.

thanks matt

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2003

Added on Jan 7 2002

11 comments

1,084 views