Home » SQL & PL/SQL » Client Tools » heading for every 10 rows (10g)
heading for every 10 rows [message #463545] Thu, 01 July 2010 15:17 Go to next message
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
Re: heading for every 10 rows [message #463547 is a reply to message #463545] Thu, 01 July 2010 15:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Could I know how to do it?

SQL> SET PAGESIZE 9999
Re: heading for every 10 rows [message #463548 is a reply to message #463545] Thu, 01 July 2010 15:35 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3106
Registered: January 2010
Location: Connecticut, USA
Senior Member
SET PAGESIZE, if you are talking SQL*Plus.

SY.
Re: heading for every 10 rows [message #463549 is a reply to message #463548] Thu, 01 July 2010 15:39 Go to previous messageGo to next message
geneeyuss
Messages: 53
Registered: June 2010
Member
thank you
Re: heading for every 10 rows [message #463573 is a reply to message #463549] Fri, 02 July 2010 00:32 Go to previous message
Michel Cadot
Messages: 68049
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*PlusĀ® User's Guide and Reference

Regards
Michel
Previous Topic: /SQL *Plus Commands ?
Next Topic: syntax file
Goto Forum:
  


Current Time: Mon Dec 06 10:51:16 CST 2021