9 Replies Latest reply: Nov 20, 2012 3:44 AM by Fran RSS

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

    923095
      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