Re: Generating Primary Key in Oracle (part 2)

[Matt Robertson]

If what you're trying to accomplish is to figure out what the most recently inserted value is (or, more accurately, the one inserted by your session) you might find this article useful:

http://www.markme.com/cantrell/archives/002201.cfm

Basically you create a surrogate pk via a uuid prior to your insert, and then use that value to query back the db for the numeric ID that just got created (via a sequence, since this is Oracle).  This lets you use a nice slim numeric pk and skip all the other gymnastics (locks, transaction blocks etc.) you would need otherwise.  All at the cost of a single text field and index.

--
-------------------------------------------
Matt Robertson,     [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
-------------------------------------------

--

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---