Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: wizardofsilence
- Content: Threads
- Order by date
-
delete data using a trigger
Q- ensure that event records can not be deleted if the "evdate" is not later than the current date I created the following trigger for this matter. CREATE OR REPLACE TRIGGER TRIGTEST3 BEFORE DELETE OR UPDATE OF evdate ON event FOR EACH ROW BEGIN IF :OLD.EVDATE >= 'SYSDATE' THEN...- wizardofsilence
- Thread
- Replies: 5
- Forum: Oracle: All versions
-
Generating an error using a trigger
I need to make a trigger which generates an error when value 'AUGUST' is entered as evdata in event. Q- ensure that event cannot be run in the month of AUGUST. I created the following trigger but the rows can be entered which include 'AUGUST' as data. create or replace trigger trigtest BEFORE...- wizardofsilence
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
insert data into an audit table
I need to enter data into an audit table using a trigger.. I created the following audit table and trigger... trigger dsnt give the expected answer... Q - if a customer gives a 0 evaluation, the details of the attendance must be placed in an audit table.. -- cusarrive is the table which has...- wizardofsilence
- Thread
- Replies: 9
- Forum: Oracle: All versions
