OraFAQ Forum: SQL & PL/SQL » spool actual scripts

Home » SQL & PL/SQL » SQL & PL/SQL » spool actual scripts

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

spool actual scripts [message #7303]

Tue, 03 June 2003 14:05

WALID
Messages: 31
Registered: August 2002

Member

Is there a way to keep the actual scripts when I spool the sql statements. I only get the results of the affected rows - I would like to list also the scripts that ran.

Report message to a moderator

Re: spool actual scripts [message #7304 is a reply to message #7303]

Tue, 03 June 2003 14:23

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

_{quote from WALID FAROUN:}
----------------------------------------------------------------------

Is there a way to keep the actual scripts when I spool the sql statements. I only get the results of the affected rows - I would like to list also the scripts that ran.

----------------------------------------------------------------------

SQL> SPOOL x1.txt
SQL> @dummy
  
D
-
X
  
SQL> SPOOL OFF
SQL> <a href="http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a82950/ch8.htm#1001850"><font color=red><b>SET ECHO ON</b></font></a>
SQL> SPOOL x2.txt
SQL> @dummy
SQL> SELECT dummy
  2  FROM   DUAL;
  
D
-
X
  
SQL> SPOOL OFF
SQL>

HTH,

A

Report message to a moderator

Previous Topic:	Date Format
Next Topic:	Error ORA-00439

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 13:51:23 CDT 2024