Home » SQL & PL/SQL » Client Tools » Column headings in sql plus
Column headings in sql plus [message #344883] Mon, 01 September 2008 10:06 Go to next message
Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore
Senior Member

Hi,
I want the column headings to printed only once in my output.

The following query returns 100 rows and the output is displayed in the below format. Repeating the column heading for every page.
I tried setting the pagesize=0 but it truncates the column heading.

select user_name,user_id
from fnd_user where rownum<=100

USER_NAME       USER_ID
--------------- -------
ANONYMOUS            -1
AUTOINSTALL           1
CONCURRENT MANA       4
....
....

USER_NAME       USER_ID
--------------- -------
PHILLM01           1324
BREENM01           1104
BRIGGS01           1105
BROCKK01           1106
BROOKJ01           1107
BROWNS01           1108
BRUCED01           1109
BURNSD01           1110

100 rows selected.


I want the column headings to be displayed only once in the output like,
USER_NAME       USER_ID
--------------- -------
PHILLM01           1324
CONFIG             1027
HOUSEKEEPER        1028
..
..
..

330 rows selected
Re: Column headings in sql plus [message #344885 is a reply to message #344883] Mon, 01 September 2008 10:07 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SQL> SET PAGESIZE=9999999999
Re: Column headings in sql plus [message #344886 is a reply to message #344883] Mon, 01 September 2008 10:14 Go to previous message
Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore
Senior Member

Thanks !!
Previous Topic: SP2-0223: No lines in SQL buffer
Next Topic: SQL*Loader-700: Out of memory while performing essential allocations
Goto Forum:
  


Current Time: Fri Dec 09 22:54:05 CST 2016

Total time taken to generate the page: 0.06633 seconds