Home » SQL & PL/SQL » SQL & PL/SQL » Partial Primay Key
Partial Primay Key [message #198421] Tue, 17 October 2006 02:34 Go to next message
highvoltage
Messages: 12
Registered: October 2006
Location: Singapore
Junior Member
Guys I have this question, I know how to add a primary key into the oracle table but how do i add a partial primary key?
Re: Partial Primay Key [message #198424 is a reply to message #198421] Tue, 17 October 2006 02:37 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I must be dumb, but - what is a partial primary key?

[EDIT] Google helped a little bit; OK, it seems that you can't have partial primary key, but you could create a unique function-based index instead. Check this Todd's answer.

[Updated on: Tue, 17 October 2006 02:39]

Report message to a moderator

Previous Topic: Creating a table with a constraint.
Next Topic: logic help
Goto Forum:
  


Current Time: Sat Dec 03 15:50:44 CST 2016

Total time taken to generate the page: 0.10602 seconds