Home » SQL & PL/SQL » SQL & PL/SQL » Is there a way to tell what Oracle tables are getting updated? (2 merged)
icon7.gif  Is there a way to tell what Oracle tables are getting updated? (2 merged) [message #442539] Mon, 08 February 2010 23:07 Go to next message
wavve31
Messages: 1
Registered: February 2010
Location: California
Junior Member
Hi,
I'm working with a new web application and I'm trying to figure out what database tables are getting updated on the back end. Is there a SQL command I can run after I perform an action in the application?


Thanks!

[Updated on: Mon, 08 February 2010 23:26] by Moderator

Report message to a moderator

Re: Is there a way to tell what Oracle tables are getting updated? [message #442544 is a reply to message #442539] Mon, 08 February 2010 23:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, there is no command.
If you want to trace what happened, activate trace.
If you want to know if a table is updated and by who, activate AUDIT.

Regards
Michel
Re: Is there a way to tell what Oracle tables are getting updated? [message #442547 is a reply to message #442539] Mon, 08 February 2010 23:14 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>Is there a SQL command I can run after I perform an action in the application?

what is wrong with SELECT?
Re: Is there a way to tell what Oracle tables are getting updated? [message #442609 is a reply to message #442547] Tue, 09 February 2010 07:06 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Quote:
what is wrong with SELECT?

Other than that it can't tell you what tables just got updated, nothing.
It's a great command - I use it all the time.
It's just no use for this.

@wavve31 - you could create a set of On Update triggers on your tables, and code them to record which record gets updated, when and by whom - that would give you the same basic information as enabling Auditing.
Previous Topic: how to use USING clause for dynamically appended where clauses
Next Topic: Enclosing comma separated values within single quotes (4 merged)
Goto Forum:
  


Current Time: Mon Dec 05 21:22:08 CST 2016

Total time taken to generate the page: 0.12133 seconds