Nuke
Replies to this thread:
More by Nuke
What people are reading
Subscribers
Please log in to subscribe to Nuke's postings.
:: Subscribe
|
PL/SQL trigger help needed.
|
[VIEWED 4039
TIMES]
|
SAVE! for ease of future access.
|
|
|
|
Nuke
Please log in to subscribe to Nuke's postings.
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.
|
| |
|
|
|
|
Nuke
Please log in to subscribe to Nuke's postings.
Posted on 04-23-06 11:16
AM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
no SQL genius in Sajha???
|
| |
|
|
Icanfly
Please log in to subscribe to Icanfly's postings.
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.)
|
| |
|
|
Hussain_Khan
Please log in to subscribe to Hussain_Khan's postings.
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
|
| |
|
|
Arko
Please log in to subscribe to Arko's postings.
Posted on 04-23-06 2:41
PM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
|
|
| |
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 365 days
| Recommended Popular Threads |
Controvertial Threads |
| Conservative discussions |
| TPS Re-registration case still pending .. |
| TPS for Nepal likely to extend next week |
| सालीको चाक |
| ChatSansar.com Naya Nepal Chat |
| TPS for Venezuela is terminated, only 60 days extension for transition period |
| TPS to F1 Status. |
| TPS To F-1 COS |
| Venezuela TPS lawuit |
| Toilet paper or water? |
| tesla stock OMG !! |
| Those who are in TPS, what’s your backup plan? |
| Biden out, Trump next president, so what’s gonna happen to TPS, termination? |
| Homeland Security revokes temporary status for 532,000 Cubans, Haitians, Nicaraguans and Venezuelans |
| TPS Sakiyo Tara Case is in Court. |
| Got my F1 reinstatement approved within 3 months(was out of F1 for almost 2 years) |
| Has anyone here successfully reinstated to F-1 status after a year-long gap following a drop from F-1? |
| I hope all the fake Nepali refugee get deported |
| and it begins - on Day 1 Trump will begin operations to deport millions of undocumented immigrants |
| Court Hearing Approval. |
|
| Looking for girl |
| Who is hottest nepali female? |
|
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.
|
