(Chuck Hamilton) writes:

>Is there a way to capture users' SELECT commands for later analysis?
>Chuck Hamilton

>This message delivered by electronic sled dogs. WOOF!


Very simple. While in SQL*Plus or SQL*DBA, and before typing the statements 
which you wish to capture, type:

SPOOL filename.lst

When you have finished typing the SELECT (or other) commands, type:


Then you can view the "filename.lst" file.

Good luck.

-Ari Kaplan
Independent Oracle DBA Consultant

<-> Visit my Web Page:                          <->
<->             email:                    <->

Back to Ari Kaplan's Home Page k to Ari Kaplan's Home Page