How to format the output in Oracle SQL*Plus?

Question

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?

Answer 1

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