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