Home » SQL & PL/SQL » Client Tools » SQL Plus, suppress these lines
SQL Plus, suppress these lines [message #247795] Wed, 27 June 2007 04:37 Go to next message
beetel
Messages: 96
Registered: April 2007
Member
I have a file run.sql:
accept tab prompt 'Enter table: ';
select * from &tab;

When I run it, it outputs:
SQL> @a
Enter table: EMPLOYEE
old   1: select * from &tab
new   1: select * from EMPLOYEE

       ENO ENAME                DNO                      SALARY
---------- -------------------- -------------------- ----------
         1 Noor                 D10                     10000.5
         2 Ahmed                D20                    20000.75
         3 jaya                 D30                    15000.65
         4 hema                 D10                     10000.5
         5 rupa                 D20                    20000.75
         6 prabha               D40                    20000.75
         7 lalitha              D40                    12000.75
         8 vetri                D40                    12000.75


Now, is there a way to suppress these lines:
old   1: select * from &tab
new   1: select * from EMPLOYEE


Thanks in advance!
Re: SQL Plus, suppress these lines [message #247808 is a reply to message #247795] Wed, 27 June 2007 05:07 Go to previous message
nnishan
Messages: 1
Registered: June 2007
Junior Member
Hi

Did you try "set verify off" option ?

SQL> set verify off
SQL> @run


Regds
Nishan
Previous Topic: set scan off error
Next Topic: editing sql commands
Goto Forum:
  


Current Time: Sat Dec 03 01:01:38 CST 2016

Total time taken to generate the page: 0.17950 seconds