Home » SQL & PL/SQL » Client Tools » How many lines of rows can be displayed through SQL PLUS (Oracle 9i)
How many lines of rows can be displayed through SQL PLUS [message #334317] Wed, 16 July 2008 03:34 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
How many lines of rows can be displayed through SQL PLUS.
I am running a query ad getting 1,46,000 rows.But problem is that
when I want to see the entire resulset by scrolling up.After a certain limit I cant see the rows at the top.

Can this be resolved by setting some parameters?

Regards,
Oli
Re: How many lines of rows can be displayed through SQL PLUS [message #334320 is a reply to message #334317] Wed, 16 July 2008 03:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Infinite can be displayed.
The number that you can scroll depends on your buffer setting.
But who scroll 146000 rows?

Regards
Michel
Re: How many lines of rows can be displayed through SQL PLUS [message #334324 is a reply to message #334320] Wed, 16 July 2008 03:45 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Through spool we can store the entire records in a text file.
But here I am not being able to do that as I have no acces to
create text file.


Is there any way to copy the entire resul set to a file?
I mean the entire records need to be copied into a text file.
Can I run any command to set increase the buffer setting using SQL plus?

Thanks for your response.
Regards,
Oli

Re: How many lines of rows can be displayed through SQL PLUS [message #334326 is a reply to message #334324] Wed, 16 July 2008 03:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any way to copy the entire resul set to a file?

This is the goal of "spool"

Quote:
Can I run any command to set increase the buffer setting using SQL plus?

No.

Regards
Michel
Re: How many lines of rows can be displayed through SQL PLUS [message #334328 is a reply to message #334326] Wed, 16 July 2008 03:51 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member

ya, I understand but I have no priviledge to create text file.
Then , How can we increase the Buffer height so that after display millions of rows I can go to the top rowby scrolling up.



Thanks,
Oli
Re: How many lines of rows can be displayed through SQL PLUS [message #334332 is a reply to message #334328] Wed, 16 July 2008 04:03 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
That Buffer setting is not an SQL*PLus setting, but a setting of your OS command window.

And you HAVE to be able to create files. At least in some temporary user directory, otherwise you wouldn't be able to work at all on your OS.
Re: How many lines of rows can be displayed through SQL PLUS [message #334335 is a reply to message #334328] Wed, 16 July 2008 04:12 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If you are saying you have no right to create any file, I can only assume that you are working through a terminal client.
In that case, it depends on your client, but for example PuTTY can save the session output in a file to your local computer.
Go to Session->Logging to do so.
Re: How many lines of rows can be displayed through SQL PLUS [message #334373 is a reply to message #334335] Wed, 16 July 2008 05:55 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
@JRowbottom

Quote:

I can only assume that you are working through a terminal client.



Yes, it is..



@Frank
Thanks for providing the alternative solution.I have putty installed i client terminal


Thanks to you all for giving your time and make me understand.Thanks you very much.

Regards,
Oli

[Updated on: Wed, 16 July 2008 05:58]

Report message to a moderator

Re: How many lines of rows can be displayed through SQL PLUS [message #334385 is a reply to message #334373] Wed, 16 July 2008 06:16 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Nice to say Hi to JRowbottom, but I don't see any replies from him in this thread..
Re: How many lines of rows can be displayed through SQL PLUS [message #334403 is a reply to message #334385] Wed, 16 July 2008 06:45 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Frank wrote on Wed, 16 July 2008 06:16
Nice to say Hi to JRowbottom, but I don't see any replies from him in this thread..



Ooops! Shocked ... apologies.Thanks Frank
Re: How many lines of rows can be displayed through SQL PLUS [message #334438 is a reply to message #334403] Wed, 16 July 2008 08:29 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm flattered that you're mistaken for me. Or should that be the other way round.... Cool
Re: How many lines of rows can be displayed through SQL PLUS [message #334464 is a reply to message #334438] Wed, 16 July 2008 11:18 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Cool Now JRowbottom is here.. Smile

[Updated on: Wed, 16 July 2008 11:19]

Report message to a moderator

Re: How many lines of rows can be displayed through SQL PLUS [message #334471 is a reply to message #334438] Wed, 16 July 2008 11:59 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
JRowbottom wrote on Wed, 16 July 2008 15:29
I'm flattered that you're mistaken for me. Or should that be the other way round.... Cool

@Maaher Wink

I know for sure that I'm the one feeling flattered!
Re: How many lines of rows can be displayed through SQL PLUS [message #334474 is a reply to message #334464] Wed, 16 July 2008 12:22 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The question is still there:
Quote:
But who scroll 146000 rows?

Regards
Michel
Previous Topic: TOAD Error with weak REF CURSOR
Next Topic: Sql Developer have problem
Goto Forum:
  


Current Time: Thu Dec 08 00:21:45 CST 2016

Total time taken to generate the page: 0.09641 seconds