Check Constraint - Alternative to subqueries?
604609Oct 22 2007 — edited Oct 29 2007Hello Oracle community,
Since Oracle does not allow the use of subqueries in check constraints statements what is the alternative that would still use a check clause? (I'm using Oracle 10g)
"Ex: alter table table1 add constraint constraint1
check ((SQL_Query1) > 0);
where SQL_Query is a select query statement. Error message is "SQL Error: ORA-02251: subquery not allowed here...".
Thank you!