Home › SQLPlus: suppress headings for SELECT

SQLPlus: suppress headings for SELECT 

Dr. Xi
Joined:
04/09/2007
Posts:
753

November 12, 2008 22:56:00    Last update: November 12, 2008 22:56:00
Set the PAGESIZE system variable to 0 to suppress headings in SELECT results. This is helpful when retrieving source code for packages or stored procedures: 
SQL> set pagesize 0
SQL> show pages
pagesize 0
SQL> select text from dba_source
  2  where type = 'PACKAGE BODY' and name = 'ACCOUNT_MGR'
  3  order by line;
Share |
| Comment  | Tags