1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

result dislpay in SQLPlus

Discussion in 'SQL PL/SQL' started by prabhur, Mar 16, 2015.

  1. prabhur

    prabhur Active Member

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    80
    I will open my SQLPlus with CMD in windows. When I write a query it shows 157998 rows as result. I want see the all result in sqlpus window, but it is not showing all the result.
     
  2. Girish

    Girish Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    65
    To view your output, spool your output to a file.

    Format your page size and line size.
     
    prabhur likes this.
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Yes, it is but it's scrolling in the window. Your first, and best, option has already been suggested, use the spool command to send the output to a text file to view later. Another option is to set your page size to, say, 25, set pause on then run the query. The output will be displayed in 25-line 'pieces' that you advance with the space bar. You can't go backwards with this option but you can see every row you return.
     
    prabhur likes this.