Home » SQL & PL/SQL » SQL & PL/SQL » Statement Level trigger - After Insert/Update (11g)
Statement Level trigger - After Insert/Update [message #684612] Wed, 07 July 2021 05:21 Go to next message
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

Re: Statement Level trigger - After Insert/Update [message #684613 is a reply to message #684612] Wed, 07 July 2021 06:05 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3104
Registered: January 2010
Location: Connecticut, USA
Senior Member
No.

SY.
Re: Statement Level trigger - After Insert/Update [message #684614 is a reply to message #684612] Wed, 07 July 2021 09:18 Go to previous messageGo to next message
EdStevens
Messages: 1350
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?
Re: Statement Level trigger - After Insert/Update [message #684670 is a reply to message #684614] Thu, 22 July 2021 11:25 Go to previous messageGo to next message
revathitirun
Messages: 16
Registered: May 2011
Junior Member


Thanks for your information .As per the business we need to capture that information.
Re: Statement Level trigger - After Insert/Update [message #684672 is a reply to message #684670] Thu, 22 July 2021 11:42 Go to previous message
Michel Cadot
Messages: 68040
Registered: March 2007
Location: Nanterre, France, http://...
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.

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


Current Time: Sat Nov 27 04:48:32 CST 2021