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.
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.
No one has followed this question yet.