Home » SQL & PL/SQL » SQL & PL/SQL » create new record with unique primary key...
create new record with unique primary key... [message #38010] Wed, 13 March 2002 10:40 Go to next message
Jared
Messages: 10
Registered: June 2001
Junior Member
How can I create a new record for a table that has a random, unique primary key? Any ideas?

Thanks,
Jared

Report message to a moderator

Re: create new record with unique primary key... [message #38021 is a reply to message #38010] Wed, 13 March 2002 18:37 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
try to use SEQUENCE object in database or create own table space to keep sequence number or check the created random primary key and check wheather it is existed in table of no before insert. Hope this is helping

Report message to a moderator

Previous Topic: code should be fairly simple but it is not working?
Next Topic: SQL code bit works but not when include PL/SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 15:36:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.