OraFAQ Forum: SQL & PL/SQL » Difference between PRIMARY KEYS and SURROGATE keys

Home » SQL & PL/SQL » SQL & PL/SQL » Difference between PRIMARY KEYS and SURROGATE keys

Mon, 30 November 2009 14:15

shabir46
Messages: 41
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

Mon, 30 November 2009 14:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Mon, 30 November 2009 14:25

ThomasG
Messages: 3212
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: Fri Jul 11 04:54:31 CDT 2025