[Show all top banners]

Nuke
Replies to this thread:

More by Nuke
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 PL/SQL trigger help needed.
[VIEWED 3338 TIMES]
SAVE! for ease of future access.
Posted on 04-23-06 3:09 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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.
 
Posted on 04-23-06 11:16 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

no SQL genius in Sajha???
 
Posted on 04-23-06 1:58 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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.)
 
Posted on 04-23-06 2:18 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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
 
Posted on 04-23-06 2:41 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

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

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


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 30 days
Recommended Popular Threads Controvertial Threads
TPS Re-registration case still pending ..
and it begins - on Day 1 Trump will begin operations to deport millions of undocumented immigrants
I hope all the fake Nepali refugee get deported
To Sajha admin
All the Qatar ailines from Nepal canceled to USA
MAGA मार्का कुरा पढेर दिमाग नखपाउनुस !
Travel Document for TPS (approved)
MAGA and all how do you feel about Trumps cabinet pick?
Those who are in TPS, what’s your backup plan?
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters