Home » Developer & Programmer » Designer » system assigned keys
system assigned keys [message #90746] Mon, 18 October 2004 11:31 Go to next message
wk
Messages: 2
Registered: October 2003
Junior Member
Does anyone have a recommendation for loading a system assigned (sequential) numeric key when inserting into an Oracle 9I table?  Can Oracle do this for us? -or-  do I need to keep track of the last used number, add one to it, and insert.

Report message to a moderator

Re: system assigned keys [message #90749 is a reply to message #90746] Tue, 19 October 2004 04:16 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Yes.

Do it the right way and use an Oracle sequence.

Report message to a moderator

Previous Topic: data modelling.
Next Topic: Problems with importation in the RON (Repository Object Navigator)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Mar 25 05:14:51 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.