I've written a system event trigger which records information on when a table was
dropped or truncated. I would also like
to record when someone does an "alter table drop column..." The problem is
determining when the alter statement includes the drop column clause. It looks like
I have to use the ora_is_drop_column function, calling it for each column in the table
and checking the return code. Is there a way of determing whether "drop column" was
issued without using this function?
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
