Home » SQL & PL/SQL » SQL & PL/SQL » Trigger for ALTER TABLE
Trigger for ALTER TABLE [message #37394] Tue, 05 February 2002 20:18 Go to next message
MILIND TENDULKAR
Messages: 1
Registered: February 2002
Junior Member
Hi!,

How to detect changes to a table - like adding, deleting a column - using trigger?

Thanks
Re: Trigger for ALTER TABLE [message #37399 is a reply to message #37394] Wed, 06 February 2002 04:08 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
write systemevent trigger on schema or database and check return values of attribute functions.
ora_is_alter_column
ora_is_drop_column

visit this link

http://www.geocities.com/suresh_vemulapalli/trig.htm
Previous Topic: Re: to_char(sysdate, 'D') - number of the day
Next Topic: PROS AND CONS: schema vs database
Goto Forum:
  


Current Time: Tue Sep 28 11:55:31 CDT 2021