RE: sqlplus

Joan --

The best way to do it is to encapsulate the SQL into an external file,
then call sqlplus with the -s option...

Someshellcommand
someshellcommand

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joan Hsieh
Sent: Tuesday, October 06, 2009 10:20 AM
To: oracle_l
Subject: sqlplus 

Hi List,

I have a shell script report the following output for my daily check 
routine. I found the SQL> SQL> SQL> is very annoying, is it possible to 
get rid off the "lines from coonected to:" to 2 3 4...13" ?

Thanks,


Joan


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing 
options

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>   2    3    4    5    6    7 
8    9   10   11   12   13
     Thread LastSeqApp1stti Last Sequence Applied LastSeqRec1stti Last 
Sequence Received    DiffSeq   DiffMins
---------- --------------- --------------------- --------------- 
---------------------- ---------- ----------
          1 06-OCT-09                        1428 06-OCT-09 
             1428          0          0
SQL> SQL> SQL>   2
CURRENT_LOG_GAP
---------------
               0
SQL> SQL>   2    3    4
PROCESS                      SEQUENCE# STATUS
--------------------------- ----------
------------------------------------
ARCH                              1426 CLOSING
ARCH                              1427 CLOSING
ARCH                              1428 CLOSING
RFS                               1429 IDLE
MRP0                              1429 APPLYING_LOG
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 
11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing 
options

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l


Other related posts: