OraFAQ Forum: Client Tools » heading for every 10 rows

Home » Other » Client Tools » heading for every 10 rows (10g)

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

heading for every 10 rows [message #463545]

Thu, 01 July 2010 15:17

geneeyuss
Messages: 53
Registered: June 2010

Member

Hi,

I would like to turn off the heading which it gives for every 10-12 rows of output in a select stmt.

I want that to be printed only at the top. not for every 10 rows. Could I know how to do it?

Thanks
geneeyuss

Report message to a moderator

Re: heading for every 10 rows [message #463547 is a reply to message #463545]

Thu, 01 July 2010 15:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Could I know how to do it?

SQL> SET PAGESIZE 9999

Report message to a moderator

Re: heading for every 10 rows [message #463548 is a reply to message #463545]

Thu, 01 July 2010 15:35

Solomon Yakobson
Messages: 3303
Registered: January 2010
Location: Connecticut, USA

Senior Member

SET PAGESIZE, if you are talking SQL*Plus.

SY.

Report message to a moderator

Re: heading for every 10 rows [message #463549 is a reply to message #463548]

Thu, 01 July 2010 15:39

geneeyuss
Messages: 53
Registered: June 2010

Member

thank you

Report message to a moderator

Re: heading for every 10 rows [message #463573 is a reply to message #463549]

Fri, 02 July 2010 00:32

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL*Plus® User's Guide and Reference

Regards
Michel

Report message to a moderator

Previous Topic:	/SQL *Plus Commands ?
Next Topic:	syntax file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 01:27:54 CST 2025