Business Rule #1-----
A student is not allowed to enroll Acct480 without previously completing Acct380 and Acct381.

Write a trigger to enforce Business Rule #1. Your trigger must be robust enough to handle any number of course offerings and any OfferNo. In other words, your trigger should not depend on particular OfferNo or number of course offerings.


Please help me create trigger for above situations.

no SQL genius in Sajha???

I would help if it was MS SQL. I don't know Oracle and PL/SQL. Also you need to be more detailed on the table structure (column etc.)

You are talking about filtering issue before inserting course in a table. But trigger has to do with only on insert, delete and update.

Your problem seems to be more on select statement that filters whether the person is allowed to register or not. Hence, trigger has nothing to do with filtering. Trigger is table specifie for on insert, delete and update.

May be I did not understand your problem statment

I agree with previous post but if you must use trigger try BEFORE trigger

http://www.techonthenet.com/oracle/triggers/before_insert.php