[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL Plus window, Increase Number of Visible Rows

Posted on 2012-09-12
Medium Priority
Last Modified: 2012-09-12
How can I increase the number of rows remaining in a SQL Plus window after a query executes?

What's driving this questions is....If a user runs a query which returns app 700 lines of data, they would like to scroll back up to the top and view all records returned.   The problem is the window only holds some many rows.

I'm wondering about something like 'buffer' or pagesize, but I haven't had any success.

Appreciate the help
Question by:DoveTails
  • 2
  • 2

Author Comment

ID: 38392331
It looks like it's the Screen Buffer size.   Can anyone tell me the syntax to enter to adjust this ? ....  as opposed to going into Properties, Layout, and increasing the Height manually ?
LVL 74

Accepted Solution

sdstuber earned 2000 total points
ID: 38392375
sql*plus simply writes to the screen,  it doesn't know anything about screen buffer size
that's an attribute of the dos command window.

So, you must set it through the properties, layout options in the command window itself,  sql*plus can't help you there

Author Closing Comment

ID: 38392390
That save me a lot of time.....Thanks
LVL 74

Expert Comment

ID: 38392400
you can issue a mode command at the command prompt (not sql*plus prompt)

mode con lines=50

it will adjust both the buffer size and the window size to be the same value unless you set it to something large.

if lines > 80 then the window size will be set to 80 and the buffer size will be set to whatever you specify

if you want to adjust them independently you'll have to go through the menus as listed above

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question