Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Problem from a beginner
You can create a PL-SQL trigger to implement this type of constraint. This would be a before insert trigger which would use the subquery that you have stated. If the error was encountered, you can rollback the record. Refer to PL-SQL triggers. Received on Sat Nov 22 1997 - 00:00:00 CST