| | |
Autogenerated Primary Key.. Pls Help !!
Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
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)
| Thread Tools | Search this Thread |
2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy enterprise enterprise2.0 enterprisesoftware federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho






