• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

output

long query output..

I want to see the pagewise output.
Can you please help me.
0
thomasliju
Asked:
thomasliju
2 Solutions
 
johnsoneSenior Oracle DBACommented:
Assuming you are talking about SQL*Plus, I will direct  you to the documentation -> http://docs.oracle.com/cd/E16655_01/server.121/e18404/ch_twelve040.htm#BACGAJIC

You would want to be looking at SET PAGESIZE and SET PAUSE initially, but that link should give you all the information you need.
0
 
thomaslijuAuthor Commented:
With this as an example what we give

SET PAGES[IZE] {14 | n}
0
 
slightwv (䄆 Netminder) Commented:
For long lines you want:
set LINESIZE 1000


Where 1000 is whatever linesize you want.

Same for PAGESIZE:  That is the number of lines per page before a page break and new set of column headers.
0
 
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now