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.
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: 2478
Registered: December 2002
Senior Member
Yes.

Do it the right way and use an Oracle sequence.
Previous Topic: What are the main steps involved for OLTP database design
Next Topic: Problems with importation in the RON (Repository Object Navigator)
Goto Forum:
  


Current Time: Sat Aug 19 04:24:56 CDT 2017

Total time taken to generate the page: 0.09750 seconds