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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by benipal

  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
See more

Part and Inventory Search

Back
Top