Home » SQL & PL/SQL » Client Tools » how to suppress heading in the sql output (oracle 10 g ver : 2 - o/s sunsolaris 5.9)
how to suppress heading in the sql output [message #325671] Sat, 07 June 2008 08:48 Go to next message
kesavansundaram
Messages: 181
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.
Re: how to suppress heading in the sql output [message #325674 is a reply to message #325671] Sat, 07 June 2008 09:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is 1 crore?
Try to set pagesize, if it does not want then it is not possible.

Regards
Michel
Re: how to suppress heading in the sql output [message #325679 is a reply to message #325674] Sat, 07 June 2008 09:21 Go to previous messageGo to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

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

thank you.
kesavan.
Re: how to suppress heading in the sql output [message #325682 is a reply to message #325671] Sat, 07 June 2008 09:28 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: how to suppress heading in the sql output [message #325686 is a reply to message #325679] Sat, 07 June 2008 09:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: how to suppress heading in the sql output [message #325828 is a reply to message #325686] Mon, 09 June 2008 02:03 Go to previous messageGo to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Simply use
SET HEADING OFF
.
Re: how to suppress heading in the sql output [message #325832 is a reply to message #325828] Mon, 09 June 2008 02:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: how to suppress heading in the sql output [message #325886 is a reply to message #325832] Mon, 09 June 2008 07:04 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not a solution for OP query:
Quote:
select * from security_table


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


Current Time: Sun Dec 04 04:57:38 CST 2016

Total time taken to generate the page: 0.10121 seconds