RE: Auditing, how to capture sql statement issued

From: Sachin Puri <sachin_at_siworldwide.com>
Date: Tue, 16 Jan 2001 20:01:12 +0530
Message-Id: <10743.126779@fatcity.com>

Cale

I think you mean to reuse the sql statement sometime again. if this is the case then u can save the query in the sql*plus editor in some file location

     or u can just use SAVE <A> after your query in the sql*plus . 
     The next time u want to use the query u can just use ' @ A ' .

e.g select * from tab;

TNAME                          TABTYPE CLUSTERID
------------------------------ ------- ---------
AB                             TABLE
CD                             TABLE
DISTINCT_TEST                  TABLE
EMP                            TABLE
LXAPPLICATION                  TABLE
LXAUCTION                      TABLE
LXAUCTIONHISTORY               TABLE
LXAUCTIONSTATUS                TABLE
LXBID                          TABLE

SQL> save a replace
Wrote file a

SQL> @ a

TNAME                          TABTYPE CLUSTERID
------------------------------ ------- ---------
AB                             TABLE
CD                             TABLE
DISTINCT_TEST                  TABLE
EMP                            TABLE
LXAPPLICATION                  TABLE
LXAUCTION                      TABLE
LXAUCTIONHISTORY               TABLE
LXAUCTIONSTATUS                TABLE
LXBID                          TABLE

you can also use the sql*plus editor by just typing 'ed' as it will load the last executed sql query in
the editor where you save your query.

Rgds,

Sachin Puri
Oracle Development and Administration
Solutions NY
Tel : +91-11-6220102 x 22
Direct : +919810373243

-----Original Message-----
From: Cale, Rick T (Richard) [mailto:RICHARD.T.CALE_at_saic.com] Sent: Tuesday, January 16, 2001 6:31 PM
To: Multiple recipients of list ORACLE-L Subject: Auditing, how to capture sql statement issued

Hi DBAs,

Is there a way to capture the actual sql statement issued while in sql*plus,worksheet,etc?

Thanks,
Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555
e-mail: caler_at_saic.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Cale, Rick T (Richard)
INET: RICHARD.T.CALE_at_saic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Tue Jan 16 2001 - 08:31:12 CST