Members   Search   Help    Register    Login   Home
Home » SQL & PL/SQL » Client Tools » Show all fetched rows? (PL/SQL 7.1.5.1398)
Show all fetched rows? [message #428491] Wed, 28 October 2009 09:00 Go to next message
wooderson
Messages: 2
Registered: October 2009
Junior Member
How can I get PL/SQL to show all rows fetched in a query? I can not find it under preferences. I know I can do page up page down but I would like all rows to show without having to do that.

Thanks.
Report message to a moderator
Re: Show all fetched rows? [message #428493 is a reply to message #428491] Wed, 28 October 2009 09:05 Go to previous messageGo to next message
delna.sexy
Messages: 387
Registered: December 2008
Location: Surat
Senior Member
Which tool are you using?

regards,
Delna
Report message to a moderator
Re: Show all fetched rows? [message #428524 is a reply to message #428491] Wed, 28 October 2009 11:45 Go to previous messageGo to next message
wooderson
Messages: 2
Registered: October 2009
Junior Member
PL/SQL Developer 7.1.5 thanks.
Report message to a moderator
Re: Show all fetched rows? [message #428530 is a reply to message #428491] Wed, 28 October 2009 12:18 Go to previous message
cookiemonster
Messages: 1437
Registered: September 2008
Location: Rainy Manchester
Senior Member
Preferences/Window Types/SQL Window/Records per page

Set it to All records.

Just bear in mind that if you do this and then query a large table it'll take a while before you see any results.
Report message to a moderator
Previous Topic:Explain plan Using toad and SQL Developer
Next Topic:Using Unix environment variables in login.sql
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 11:39:28 CST 2009

Total time taken to generate the page: 0.60003 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.