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

Report message to a moderator

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

Report message to a moderator

Previous Topic: Re: to_char(sysdate, 'D') - number of the day
Next Topic: PROS AND CONS: schema vs database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 27 19:32:56 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.