OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » surrogate key

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

surrogate key [message #187054]

Thu, 10 August 2006 12:51

sonia_sonia
Messages: 1
Registered: August 2006

Junior Member

hi all,
does anyone know how to create surrogate key using pl/sql.I cant find any suitable example on the net.
please anyone who can help
Thank-you Razz

Report message to a moderator

Re: surrogate key [message #187057 is a reply to message #187054]

Thu, 10 August 2006 13:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

use a SEQUENCE

Report message to a moderator

Re: surrogate key [message #187299 is a reply to message #187054]

Fri, 11 August 2006 14:09

Bill B
Messages: 1971
Registered: December 2004

Senior Member

I used the search words "surrogate key oracle" on google and it returned 123000 hits. Try it your self.

Report message to a moderator

Re: surrogate key [message #201958 is a reply to message #187299]

Tue, 07 November 2006 10:22

anonymous.nospam
Messages: 2
Registered: November 2006

Junior Member

Use the following command to create a sequence called MySequence:

CREATE SEQUENCE MySequence;

Each time you use MySequence.NextVal you will get a new value. For example:

INSERT INTO MyTable(id,name)
VALUES (MySequence.NextVal,'John Do');

You can read the pros and cons of surrogate keys in this thread.

Hope it helps...

Report message to a moderator

Re: surrogate key [message #201962 is a reply to message #201958]

Tue, 07 November 2006 10:28

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

http://asktom.oracle.com/pls/ask/f?p=4950:8:16554651565849651781::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6723299263475

i already too late...

Report message to a moderator

Previous Topic:	automatically populate UID field
Next Topic:	what should i do?? - hints?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 10:38:17 CST 2024