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 gkittelson 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. benipal

    Update trigger

    Hi Bill Address is never NULL and I want to update the who_modified and when_modified fields with user and sysdate whenever there is change in address value.
  2. benipal

    Update trigger

    I have a test database which is a copy of the live database. I am trying the following scripts on test database. ALTER TABLE EMPLOYEE add (who_created varchar(30), when_created date ); ALTER TABLE EMPLOYEE modify (who_created default user, when_created default sysdate ); ALTER TABLE...
  3. benipal

    Update trigger

    hi Mufasa I am using an application to insert/update record in table. The same SAVE button is used to create or update employee record. When I change and save the address, it shows the updated address but modifydate field still NULL. I see no error message while executing trigger. Please advise,
  4. benipal

    Update trigger

    create or replace trigger modifyemployee after update of address on employee begin update employee set modifydate=sysdate // i can't figure out the code to go over here end; thanks
  5. benipal

    Update trigger

    Hi I want to capture the system date into 'modifydate' field in my 'employee' table whenever there is change in the value of the 'address' field of the 'employee' table. Looking for a trigger for this task. I am using Oracle 9i Thank you

Part and Inventory Search

Back
Top