OraFAQ Forum: Client Tools » how to suppress heading in the sql output

Home » Other » Client Tools » how to suppress heading in the sql output (oracle 10 g ver : 2 - o/s sunsolaris 5.9)

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

how to suppress heading in the sql output [message #325671]

Sat, 07 June 2008 08:48

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

dear sir,

i have 97 rows in security_table.
when i issue select * from security_table...in the output...
at first colum heading is getting printed...and it is getting printed after 14 rows ( bcos my pagesize is 14 ) ....now i need to suppress this column head repetation...it should get print at once...that is at the extreme top...not in the middle...
if i set pagesize 97 ( set pagesize 97 ) ....it is coming correctly..ie.. at first column is getting printed... and in the middle there is no column....

my question is, suppose, iam having 1 crore records in the table.... so can i set pagesize to 1 crore ?
if not possible, is there any other alternate... ?

we need to print the colum heading at once which should be at top only..
pls guide me
thank you
kesavan.

Report message to a moderator

Re: how to suppress heading in the sql output [message #325674 is a reply to message #325671]

Sat, 07 June 2008 09:11

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

Senior Member
Account Moderator

What is 1 crore?
Try to set pagesize, if it does not want then it is not possible.

Regards
Michel

Report message to a moderator

Re: how to suppress heading in the sql output [message #325679 is a reply to message #325674]

Sat, 07 June 2008 09:21

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

sir, thank you for your prompt reply.
we have set the pagesize now..

thank you.
kesavan.

Report message to a moderator

Re: how to suppress heading in the sql output [message #325682 is a reply to message #325671]

Sat, 07 June 2008 09:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above

Please practice using PREVIEW button.

Report message to a moderator

Re: how to suppress heading in the sql output [message #325686 is a reply to message #325679]

Sat, 07 June 2008 09:34

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

Senior Member
Account Moderator

Quote:

so can i set pagesize to 1 crore ?

Quote:

we have set the pagesize now..

And the result is?

Regards
Michel

Report message to a moderator

Re: how to suppress heading in the sql output [message #325828 is a reply to message #325686]

Mon, 09 June 2008 02:03

fortunethiyagu
Messages: 94
Registered: December 2006

Member

Simply use

SET HEADING OFF

Report message to a moderator

Re: how to suppress heading in the sql output [message #325832 is a reply to message #325828]

Mon, 09 June 2008 02:23

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

Senior Member
Account Moderator

"set heading off" suppress the headers everywhere including on the first page, OP wants the headers on the first page:

Quote:

now i need to suppress this column head repetation...it should get print at once

Regards
Michel

Report message to a moderator

Re: how to suppress heading in the sql output [message #325886 is a reply to message #325832]

Mon, 09 June 2008 07:04

fortunethiyagu
Messages: 94
Registered: December 2006

Member

Oh ok.. now i got it ..
I got the same problem once.
I just got it from dual as follows... guess this would be one of the solution...

select 'Header1'||chr(9)||'Header2'||chr(9))||'Header3' from dual;

chr(9) provides defined space.

thiyagarajan palanisamy

[Updated on: Mon, 09 June 2008 07:04]

Report message to a moderator

Re: how to suppress heading in the sql output [message #325902 is a reply to message #325886]

Mon, 09 June 2008 07:57

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

Senior Member
Account Moderator

This is not a solution for OP query:

Quote:

select * from security_table

Regards
Michel

Report message to a moderator

Previous Topic:	Free 3rd Party Tools
Next Topic:	getting ORA-3135 and also ORA-3134 simultaneously

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 07:03:00 CST 2025