Home » SQL & PL/SQL » SQL & PL/SQL » Difference between PRIMARY KEYS and SURROGATE keys
Difference between PRIMARY KEYS and SURROGATE keys [message #433219] Mon, 30 November 2009 14:15 Go to next message
shabir46
Messages: 40
Registered: November 2009
Member
Hi All,


Please can you tell me , what is the difference between PRIMARY KEYS and SURROGATE KEYS in oracle?

Thanks and regards,
Shabir Kaithayil
Re: Difference between PRIMARY KEYS and SURROGATE keys [message #433221 is a reply to message #433219] Mon, 30 November 2009 14:24 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
http://www.lmgtfy.com/?q=difference+between+PRIMARY+KEYS+and+SURROGATE+KEYS
Re: Difference between PRIMARY KEYS and SURROGATE keys [message #433222 is a reply to message #433219] Mon, 30 November 2009 14:25 Go to previous message
ThomasG
Messages: 3184
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
A surrogate key is a special case of a primary key. Not only in Oracle, but in all database systems.

Wikipedia Article
Previous Topic: maintain history of all updates for a table and all relational tables
Next Topic: Oracle a multi dimentional database?
Goto Forum:
  


Current Time: Sun Sep 25 23:13:06 CDT 2016

Total time taken to generate the page: 0.06067 seconds