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!

Register Log in
  • Congratulations IamaSherpa 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: *

  1. eiram00

    Help with Triggers

    I remade my trigger, but I don't understand why when I create my Trigger I get a prompt asking me to put a value on the old and new keywords. Here is my code: CREATE OR REPLACE TRIGGER MYSCH.APPT_RESCHEDULE BEFORE UPDATE OF appointment ON MYSCH.TBL_RESCHEDULE REFERENCING NEW AS NEW OLD AS OLD...
  2. eiram00

    Help with Triggers

    jimirvine Thank you for your help. This code updates only the row that I'm updating or it updates all the table?
  3. eiram00

    Help with Triggers

    This is the first trigger that I'm making. I'm trying to make a trigger to update only the field from the same row that is updated when another field from the same row is updated. I'm doing something wrong. Here is my code: CREATE OR REPLACE TRIGGER MYSCH.APPT_RESCHEDULE BEFORE UPDATE OF...

Part and Inventory Search

Back
Top