I am using Oracle SQL plus. I get the output in the format below, but I want the title to appear once only, which is at the top. How can I achieve this?

CodePudding user response：

You can use:

SET PAGESIZE 50000

To change the number of lines on a page (before the headers are repeated).

Or, if you do not want any headers then:

SET PAGESIZE 0