This discussion is archived
9 Replies Latest reply: Nov 20, 2012 1:44 AM by Fran RSS

I want to remove following line as i m using script..SPOOL is not used here

923095 Newbie
Currently Being Moderated
Hi Team,

1.SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 19 08:47:36 2012
2.
3.Copyright (c) 1982, 2011, Oracle. All rights reserved.
4.
5.
6.Connected to:
7.Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
8.With the Partitioning, OLAP, Data Mining and Real Application Testing options
9.
SQL> SQL> 2 3
NAME LOG_MODE INVALID_OBJECTS INVALID_N/A_INDEXES Invalid Triggers Broken Jobs Block Corruption
--------- ------------ --------------- ------------------- ---------------- ----------- ----------------
DBAS ARCHIVELOG 530 530 6 16 0
10.
11.SQL> SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
12.With the Partitioning, OLAP, Data Mining and Real Application Testing options



I dont want above line numbered: 1-9 and 10-12 to appear when i login into sqlplus, Please suggest how to switch them off as i need just data between those. i.e line 11-12-13 only

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points