RE: sqlplus

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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 Received on Tue Oct 06 2009 - 10:31:23 CDT