Home » SQL & PL/SQL » SQL & PL/SQL » Column Header row (sqlplus 8.0)
Column Header row [message #319302] Fri, 09 May 2008 13:22 Go to next message
sguider
Messages: 8
Registered: May 2008
Junior Member
I am trying to remove the header row from my query results and only include it on one line that being the first line of the output. I know how to set header off and remove it all together but that is not what I want to do. I have even set pagesize 0 and this does not work.
Thanks
Re: Column Header row [message #319303 is a reply to message #319302] Fri, 09 May 2008 13:24 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Is your output more than 50,000 lines? If not, set your pagesize to that (ie. the maximum allowed).
Re: Column Header row [message #319305 is a reply to message #319303] Fri, 09 May 2008 13:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And if the output is more than 50,000 lines you should seriously consider it. Who read 50,000 lines?

Regards
Michel
Re: Column Header row [message #319312 is a reply to message #319303] Fri, 09 May 2008 14:32 Go to previous messageGo to next message
sguider
Messages: 8
Registered: May 2008
Junior Member
It is more than 50000. It's going to be used to populate a test DB.
Re: Column Header row [message #319313 is a reply to message #319302] Fri, 09 May 2008 14:43 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>It is more than 50000. It's going to be used to populate a test DB.
This is like using a hammer to divide a board into 2 pieces.
In My Opinion, spooling is the wrong tool to load a test DB,
but you are free to do things the hard way.
Re: Column Header row [message #319316 is a reply to message #319312] Fri, 09 May 2008 15:22 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
sguider wrote on Fri, 09 May 2008 15:32
It is more than 50000. It's going to be used to populate a test DB.


Then why have a header at all?

Incidentally, I have used a hammer to split a board in two, when it didn't need to be two equal parts. That, and me jumping on it Wink
Re: Column Header row [message #319317 is a reply to message #319313] Fri, 09 May 2008 15:29 Go to previous messageGo to next message
sguider
Messages: 8
Registered: May 2008
Junior Member
That's why I posted in the newbie section. Looking for any helpful suggestions. The header row was requested because it was thought that a field was missing and they want to check against the header row.

[Updated on: Fri, 09 May 2008 15:35]

Report message to a moderator

Re: Column Header row [message #319319 is a reply to message #319302] Fri, 09 May 2008 15:47 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>The header row was requested because it was thought that a field was missing
You do NOT need 50000+ rows to validate all the columns exist & are in the correct order.
Previous Topic: Dont know how to write it...
Next Topic: monitor files
Goto Forum:
  


Current Time: Sat Dec 03 06:19:09 CST 2016

Total time taken to generate the page: 0.10025 seconds