Set Pause On

Adnan Khurshid on April 4th, 2011

For large output which is not able to fit in a single window, scrolling the results can skip data while it looks messy as well. to get rid of scrolling, you can use the command “set pause on”. With pause ON, the output will come in small chunks and will continue only when you press […]

Continue reading about How to get rid of scrolling for long SQL output in Oracle