Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: set head on
On Oct 22, 12:47 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Jake" <jgarfi..._at_earthlink.net> a écrit dans le message de news: 1193016259.363540.207..._at_e34g2000pro.googlegroups.com...
> | okay, this may be a dumb question but:
> |
> | why am I not getting any headers in SQL*Plus? see output below:
> |
> | SQL> set head on
> | SQL> select * from user_procedures;
> | TRAP_ERRCODE NO NO
> | NO NO
> | NO
> | DEFINER
> |
> | EMPLOYEEAGE NO NO
> | NO NO
> | NO
> |
> |
> | what do I have to do to get the headers above the columns when i do a
> | select?
> |
>
> Because you have pagesize 0
>
> Regards
> Michel Cadot
As Michel pointed out "pagesize 0" will also set the heading off. In cases where you would like the heading just once and you do not have too large a result set just set the pagesize 9999 (larger than the output set)
Pagesize 0 is very useful for spooling delimited data files and when reporting via SQLPlus.
HTH -- Mark D Powell -- Received on Mon Oct 22 2007 - 08:41:43 CDT