OraFAQ Forum: SQL & PL/SQL » schema level dml trigger

Home » SQL & PL/SQL » SQL & PL/SQL » schema level dml trigger (oracle 10g)

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

schema level dml trigger [message #683903]

Wed, 03 March 2021 23:51

pradeep08
Messages: 1
Registered: March 2021

Junior Member

how to find affected tables(DML) for a each request using schema level trigger

Report message to a moderator

Re: schema level dml trigger [message #683906 is a reply to message #683903]

Thu, 04 March 2021 00:38

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

Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

Your question is not clear: a query does not a trigger, a statement may trigger a trigger which can be a row or statement trigger, not a schema level one (but maybe on error).
So your title "schema level dml trigger" does not exist.

[Updated on: Thu, 04 March 2021 00:40]

Report message to a moderator

Re: schema level dml trigger [message #683911 is a reply to message #683903]

Thu, 04 March 2021 12:32

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

pradeep08 wrote on Wed, 03 March 2021 23:51

how to find affected tables(DML) for a each request using schema level trigger

Please explain more fully your desired end-point. It sounds like you are trying to re-invent AUDIT.

Report message to a moderator

Previous Topic:	Oracle: sql update on field containing sql itself
Next Topic:	How to call/execute a visual basic script using PL / SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 01 04:54:09 CDT 2026