SQL Behind Oracle Reports [message #400920] |
Thu, 30 April 2009 06:57 |
urwethe
Messages: 11 Registered: November 2008 Location: New Jersey
|
Junior Member |
|
|
Hi,
How can I find the SQL code that runs behind any given Oracle report from my client PC?
For example, in some of the on-line lookup applications, after looking up information,
I can select
Help/Diagnostics/Examine
Block: SYSTEM
Field: Last_Query
and this will return the SQL statement that happens behind the scenes.
I want to accomplish the same thing, perhaps from a log file, that shows me the SQL that is generated when a report is run.
|
|
|