Re: Triggers
Firstly you should be storing the timestamp as a timestamp datatype or datetime and not as a string.
Triggers allow you to use pseudo values NEW.jobnum for the new job number and OLD.jobnum for the old one. However, there does not appear to be any kind of relationship between your tables to be able to figure out the job number based on the update trigger of the respondent table. You will need to figure that out in order to use the information available to you to determine which row should be updated.
Ronan Cashell
Senior Oracle/MySQL Administrator
IT Integrated Business Solutions
http://www.it-iss.com
Subject
Views
Written By
Posted
2738
April 20, 2011 03:17PM
Re: Triggers
1047
April 20, 2011 04:51PM
1413
April 21, 2011 11:03AM
1006
April 21, 2011 01:17PM
1071
April 21, 2011 02:53PM
951
April 21, 2011 05:16PM
1046
April 21, 2011 07:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.