OraFAQ Forum: SQL & PL/SQL » inserting into records with primary key

Home » SQL & PL/SQL » SQL & PL/SQL » inserting into records with primary key

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

inserting into records with primary key [message #8392]

Fri, 15 August 2003 02:39

Stanley Beamish
Messages: 1
Registered: August 2003

Junior Member

I'm sure this is an often asked question, but I can't find an answer. If I have a table which includes a unique primary key, and I want to insert a new row, then how do I know what value to give the primary key without first doing a query to find out the current value. Is there an 'auto' mode as in MSAccess.

Cheers,
SB

Report message to a moderator

Re: inserting into records with primary key [message #8395 is a reply to message #8392]

Fri, 15 August 2003 08:00

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

_{quote from Stanley Beamish:}
----------------------------------------------------------------------

I'm sure this is an often asked question, but I can't find an answer. If I have a table which includes a unique primary key, and I want to insert a new row, then how do I know what value to give the primary key without first doing a query to find out the current value. Is there an 'auto' mode as in MSAccess.

Cheers,
SB

----------------------------------------------------------------------
Stanley,

In Oracle, the customary method employed to meet your requirement is a sequence.

HTH,

A.

Report message to a moderator

Previous Topic:	Reg:SQL Query.........
Next Topic:	Accessing from multiple partitions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 14:24:34 CDT 2024