When detail_comments in the testable is inserted or updated too then I want it to update the various_comments column which is in the same table (testtable). What would be the most efficient way to write the trigger to do this?
CREATE OR REPLACE TRIGGER ADD_TO_TESTTABLE AFTER INSERT OR UPDATE ON TESTTABLE FOR EACH ROW ????? UPDATE :NEW.VARIOUS_COMMENTS ..??????? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).