April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- Filename: trg_regions.sql
-- Purpose: Creates trigger(s) on table REGIONS.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 12-Jan-1998
---------------------------------------------------------------------------
set echo on
set termout on
spool trg_regions.log
CREATE OR REPLACE TRIGGER t_br_iu_regions
BEFORE INSERT OR UPDATE
ON regions
FOR EACH ROW
BEGIN
IF (dbms_reputil.from_remote != TRUE)
THEN
:new.audit_date := SYSDATE;
:new.audit_user := USER;
:new.global_name := DBMS_REPUTIL.GLOBAL_NAME;
END IF;
END;
/
spool off