Can we use logical operators, Conditional operators other than relational operator in query of Constraints?, because I am having an error
Below is the query I tried
Alter table arbab ADD CONSTRAINT abc CHECK (gender 'Male' or 'female');
I am having below mentioned error:
Error starting at line 1 in command:
Alter table arbab ADD CONSTRAINT abc CHECK (gender 'Male' or 'female')
Error report:
SQL Error: ORA-00920: invalid relational operator
00920. 00000 - "invalid relational operator"
*Cause:
*Action:
This query:
Alter table arbab ADD CONSTRAINT abc CHECK (gender >10);
Worked fine.
Thanks in advance.