Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

How to get next ID in a table ?

bootstrapNov 21 2010 — edited Nov 21 2010
Hi,
suppose a table has first column as ID that stores unique ID in this format : P000001,P000002,P000003... and so on.
How can i get the next value through query ?After getting that ID insert query will be applied .
This post has been answered by Hoek on Nov 21 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2010
Added on Nov 21 2010
3 comments
12,748 views