SQL Plus window, Increase Number of Visible Rows

Posted on 2012-09-12
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
    LVL 5

    Author Comment

    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 73

    Accepted Solution

    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
    LVL 5

    Author Closing Comment

    That save me a lot of time.....Thanks
    LVL 73

    Expert Comment

    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

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Suggested Solutions

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious sideā€¦
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now