question

OracleApprender avatar image
OracleApprender asked

How to see the output of the query in page by page ?

If we have more records in the table EMP then how to see the output of the query "SELECt * FROM EMP" in page wise. Thank you in advance.

queryoracle
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What program are you using to connect to Oracle and run your query?
0 Likes 0 ·

1 Answer

· Write an Answer
KillerDBA avatar image
KillerDBA answered

If you're using SQL*Plus, there's a

set pagesize <n>

command you can use.

However, if I wanted to look at something formatted nicely for reading by page, I think I'd just go ahead and create an Access report. Access isn't quite ubiquitous but it's very common and the report mechanism is easy to use. Alternatively, you could run a query in Excel to populate a formatted page. We do that often.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.