OraFAQ Forum: SQL & PL/SQL » Statement Level trigger

Home » SQL & PL/SQL » SQL & PL/SQL » Statement Level trigger - After Insert/Update (11g)

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

Statement Level trigger - After Insert/Update [message #684612]

Wed, 07 July 2021 05:21

revathitirun
Messages: 16
Registered: May 2011

Junior Member

Hi All,

I had a statement-level trigger on the table after UPDATE or INSERT. I have a requirement to capture the old and new values after the Update.
Is there any other way apart from changing into the row-level trigger

Thanks in Adavnce
Revathi

Report message to a moderator

Re: Statement Level trigger - After Insert/Update [message #684613 is a reply to message #684612]

Wed, 07 July 2021 06:05

Solomon Yakobson
Messages: 3305
Registered: January 2010
Location: Connecticut, USA

Senior Member

No.

SY.

Report message to a moderator

Re: Statement Level trigger - After Insert/Update [message #684614 is a reply to message #684612]

Wed, 07 July 2021 09:18

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

Quote:

I have a requirement to capture the old and new values after the Update

As Solomon said, "no".

And I'd ask, "what would you do with these values after you have 'captured' them?

Report message to a moderator

Re: Statement Level trigger - After Insert/Update [message #684670 is a reply to message #684614]

Thu, 22 July 2021 11:25

revathitirun
Messages: 16
Registered: May 2011

Junior Member

Thanks for your information .As per the business we need to capture that information.

Report message to a moderator

Re: Statement Level trigger - After Insert/Update [message #684672 is a reply to message #684670]

Thu, 22 July 2021 11:42

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This does not answer Ed's question.
Maybe the answer to this question will lead to a solution which you currently can't have.

Report message to a moderator

Previous Topic:	How to stop swapping in EXCHANGE PARTITION
Next Topic:	Prime Generation Logic using in single Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 15 03:32:08 CST 2025