|
-- -- BUILD_LOG_TABLE.sql -- -- Peter Robson, March 2001. -- set echo off -- -- This is a simple 3-column table; stores Name of table having a modification -- applied to it; Nature of that modificatio (Insert, Update, or Delete), and -- Date of that modification. -- -- No fatal error will coocur should the table already exist. -- set termout off -- create table LOG_MODS (table_name varchar2(30) not null, aud_flag char(1) not null, aud_date date) ; -- set termout on desc LOG_MODS set echo on -- |
|