Home » SQL & PL/SQL » SQL & PL/SQL » Surrogate key
Surrogate key [message #280331] Tue, 13 November 2007 04:37 Go to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

Can anyone explain how to implement surrogate key concept in Oracle tables?

Thanks...
Re: Surrogate key [message #280358 is a reply to message #280331] Tue, 13 November 2007 05:40 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Use sequences
Re: Surrogate key [message #280371 is a reply to message #280358] Tue, 13 November 2007 06:15 Go to previous messageGo to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

Can you please give me an example?

Thanks...
Re: Surrogate key [message #280374 is a reply to message #280331] Tue, 13 November 2007 06:20 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
AskTom:
Surrogate keys and their use in Data warehousing
normalize and surrogate key in oltp
surrogate Key

Regards
Michel
Previous Topic: Date Query
Next Topic: Export or import data with CSV file
Goto Forum:
  


Current Time: Wed Dec 07 07:04:00 CST 2016

Total time taken to generate the page: 0.16678 seconds