Autogenerated Primary Key.. Pls Help !!
Please support our Oracle advertiser: Programming Forums
![]() |
you need to create a sequence. As you can guess this is an object that gives you numbers from sequence. then you should get next value from sequence. so you will always have different pk. here is a link that shows you how to create and use it.
after creating it you will probably do something like that
insert into a(pk,col1,col2) values (sqn.nextval,'value1','value3')
after creating it you will probably do something like that
insert into a(pk,col1,col2) values (sqn.nextval,'value1','value3')
![]() |
Other Threads in the Oracle Forum
- Previous Thread: Dabase programmer
- Next Thread: Design question (schemas)
•
•
•
•
Views: 915 | Replies: 2 | Currently Viewing: 1 (0 members and 1 guests)






Linear Mode