Hi,
When a user clicks on Save Button on a form, can we know from sql plus (Oracle) all the related queries (insert/Update etc)
for that transaction ??
Please let me know.
Thanks ...
Printable View
Hi,
When a user clicks on Save Button on a form, can we know from sql plus (Oracle) all the related queries (insert/Update etc)
for that transaction ??
Please let me know.
Thanks ...
You can use transaction id before you commit. Here is an Ask Tom with that information.
All you need to do is write it to the screen. You might make this a debug option.
http://asktom.oracle.com/pls/asktom/...30725030554956