- Define an Oracle sequence
- Apply sequence to your table.column before INSERT (either in your
application or through pre-insert row trigger)
Fairly easy stuff
regards,
M. Armaghan Saqib
- SQL PlusPlus : Add power to SQL Plus command line
- SQL Link for XL : Integrate Oracle with XL
- Oracle CBT with sample GL (Triggers and Forms Source Code included.
Download free: http://www.geocities.com/armaghan/
John Shaft <shaft_at_meanmutha.com> wrote in message
news:Pine.LNX.4.10.9912171604300.29563-
100000_at_alfred.laffeycomputer.com...
> Hi,
>
> Does Oracle has a way to define a table such that the primary key gets
> auto-incremented with each new insertion? If not, how do you keep your
> primary keys unique? (With a store value read and incremented in a
> transaction?)
>
> I have a databse devloped orignally for MySQL and want to port it to
> Oracle 8. I wondered about this issue.
>
> Thanks!
>
>
> shaft_at_meanmutha.com
> http://www.meanmutha.com
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Dec 17 1999 - 18:37:21 CST