OraFAQ Forum: Client Tools » Column headings in sql plus

Home » Other » Client Tools » Column headings in sql plus

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Column headings in sql plus [message #344883]

Mon, 01 September 2008 10:06

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

Report message to a moderator

Re: Column headings in sql plus [message #344885 is a reply to message #344883]

Mon, 01 September 2008 10:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> SET PAGESIZE=9999999999

Report message to a moderator

Re: Column headings in sql plus [message #344886 is a reply to message #344883]

Mon, 01 September 2008 10:14

Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore

Senior Member

Thanks !!

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 12:05:18 CST 2024