Home » SQL & PL/SQL » SQL & PL/SQL » Trigger (Oracle 10g R2,Windows)
Trigger [message #448376] Tue, 23 March 2010 01:26 Go to next message
Messages: 74
Registered: October 2009
Location: Dhaka
dear all,

I am using oracle 10g R2 in windows environment. I have a database with a user named PIDPS which contains multiple tables.

Different entry users entered data into the respective table.Now I want to create a trigger where after update or delete from any table, a record is inserted into a specific table.

I would not like to create trigger after delete or update on specific table.

Is there any solution regarding this problem?

Please help me anyone.


Re: Trigger [message #448378 is a reply to message #448376] Tue, 23 March 2010 01:37 Go to previous messageGo to next message
Messages: 7880
Registered: March 2000
Senior Member
No. If you want to use triggers for this, you will have to create one on each and every table you want to monitor.
An alternative might be auditing (never used it myself, but others here can tell you all about it)
Re: Trigger [message #448441 is a reply to message #448376] Tue, 23 March 2010 07:11 Go to previous message
Kevin Meade
Messages: 2099
Registered: December 1999
Location: Connecticut USA
Senior Member
So mahmud732, do you understand Frank's answer?

Previous Topic: procedure taking time
Next Topic: Split varchar field into 2 fields ,SQL
Goto Forum:

Current Time: Mon Oct 24 20:23:22 CDT 2016

Total time taken to generate the page: 0.08236 seconds