Re: set head on

From: gazzag <gareth_at_jamms.org>
Date: Mon, 22 Oct 2007 02:27:52 -0700
Message-ID: <1193045272.287006.117450@k35g2000prh.googlegroups.com>

On 22 Oct, 02:24, Jake <jgarfi..._at_earthlink.net> wrote:
> 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?

SQL> set pagesize 40

HTH -g Received on Mon Oct 22 2007 - 04:27:52 CDT