TRAKING SQL STATEMENT / HIDING SQL STAEMENT [message #21675] |
Thu, 22 August 2002 03:12 |
SHARMA POLPE
Messages: 5 Registered: July 2002
|
Junior Member |
|
|
hi
i want to trak the statement issued from SQL PROMPT
(PLU33) AND creating all SQL statement a batch file
which cannot be open only executing from dos PROMPT /SQL PROMPT
MOST URGET HELP ME OUT
BY PSR
|
|
|
Re: TRAKING SQL STATEMENT / HIDING SQL STAEMENT [message #21684 is a reply to message #21675] |
Thu, 22 August 2002 10:12 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Your question is not very clear to me. You could used auditing to track many (but not all) statements. In 9i I think you can track all statements.
If you want to capture the statements run through sqlplus, you could just set echo on and start spooling to a file before you execute the sql script. By editing login.sql - you can put the spool commands etc into there so that they are automatically executed when sqlplus starts. If your script issues it's own spool command then you can't use this method.
|
|
|