OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Trigger [message #8869]

Tue, 30 September 2003 20:09

Dushm
Messages: 11
Registered: September 2002

Junior Member

I have a row level trigger for INSERT and UPDATE. My question is : Is it possible to see that the trigger is not fired when one particular column is updated ie

If my table TB1 has 4 columns col1,col2,col3,col4. I don't want the trigger to be fired if only col3 is updated.

Is this possible..?

Report message to a moderator

Re: Trigger [message #8870 is a reply to message #8869]

Tue, 30 September 2003 23:33

Reema
Messages: 50
Registered: July 2003

Member

Hi,
In your trigger code you can include the statement
--before Update of Col3
This statement will invoke the trigger only when col3 is updated else it will not be fired.Any doubts you can revert back.

Report message to a moderator

Re: Trigger [message #8888 is a reply to message #8870]

Wed, 01 October 2003 11:36

Dushm
Messages: 11
Registered: September 2002

Junior Member

Hi Reema,

Thanks for your reply.

My situation is , that the trigger should NOT be fired when col3 is updated. In realtime my table has around 25 columns.

Report message to a moderator

Re: Trigger [message #8890 is a reply to message #8869]

Wed, 01 October 2003 11:46

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

There's a big difference between not firing the trigger "when one particular column is updated" and "if only col3 is updated."

For the second statement, I would suggest something like:

before insert or update of col1, col2, col4, ..., col25 on t

Report message to a moderator

Re: Trigger [message #8899 is a reply to message #8890]

Wed, 01 October 2003 14:40

Dushm
Messages: 11
Registered: September 2002

Junior Member

Hi Todd,

I want the trigger NOT to fire when col3 is updated.
Could you please let me know how it can be done.

Report message to a moderator

Re: Trigger [message #8900 is a reply to message #8899]

Wed, 01 October 2003 15:08

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

That's exactly what I was showing you - do you see col3 listed in the column list? No. If it is not there, the trigger will not fire.

Report message to a moderator

Previous Topic:	Compile all Code on DB Change?
Next Topic:	Make an End to a user session

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 20:20:23 CDT 2024