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.
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: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Which tool are you using?

regards,
Delna
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.
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: 12422
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.
Previous Topic: Worksheet (Oracle 8/9i database tool)
Next Topic: Using Unix environment variables in login.sql
Goto Forum:
  


Current Time: Sat Dec 10 20:36:33 CST 2016

Total time taken to generate the page: 0.19063 seconds