RE: sqlplus
- From: "Bellows, Bambi (Comsys)" <bbel5@xxxxxxxxxxxx>
- To: <joan.hsieh@xxxxxxxxx>, "oracle_l" <ORACLE-L@xxxxxxxxxxxxx>
- Date: Tue, 6 Oct 2009 10:31:23 -0500
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
