Re: Need help with Multi-field UNIQUE key
Hi Samuel,
We can have unique key only if all values are unique. I think you might need to do it through program code.
The other solution which i would like to suggest is as follows:
Use Number column instead of Enaum data type. The value if negative example -1 will be assumed as 'A' and other values will always be unique numbers.
~Vinod
Subject
Views
Written By
Posted
2893
November 03, 2008 12:31PM
Re: Need help with Multi-field UNIQUE key
2043
November 04, 2008 12:06AM
1767
November 04, 2008 02:09PM
1786
November 07, 2008 11:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.