This content has been marked as final. Show 6 replies
It depends on why you want to restrict that entry - what is the general scenario here?
Constraints may reference multiple columns but you cannot do certain things within the constraint. The limitations are in the 'Concepts' manual.
Hi the ques.. is not very clear still as per ur req. u can try using composite unique key..
SQL> create table test_navneet(
2 a number(2),
3 b number(2),
4 constraint un_a_b unique (a,b));
insert into test_navneet values(&a,&b);
SQL> select * from test_navneet;
create table test (
constraint un_a_b check (a<>3 or b <>1);
Test it with inserts.
I think you mean a<>3 AND b<>1,
he does not want to allow that combo, not a=3 or b=1.
And the thread resurrection award goes to...
Sorry! I got it!
Message was edited by: