Home » SQL & PL/SQL » SQL & PL/SQL » schema level dml trigger (oracle 10g)
schema level dml trigger [message #683903] Wed, 03 March 2021 23:51 Go to next message
pradeep08
Messages: 1
Registered: March 2021
Junior Member
how to find affected tables(DML) for a each request using schema level trigger
Re: schema level dml trigger [message #683906 is a reply to message #683903] Thu, 04 March 2021 00:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
EdStevens
Messages: 1376
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.
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:
  


Current Time: Fri Mar 29 00:51:36 CDT 2024