Why does Oracle Sql * Plus print many unnecessary headers?

Question

When I run the sql statement, which should return the exact single row, sqlplus column names many times? why?

Answer 1

Probably because your page size is much smaller than the number of lines needed to display the data due to wrapping. It repeats the title on each "page" of output, even if it has not completed showing one line.

To view / copy the entire output as a whole, try SET PAGESIZE 10000(or some other large amount).

, , ( - ). , , , , - .

^{SET LINESIZE - .}

Answer 2

- . sqlplus SET:

http://ss64.com/ora/syntax-sqlplus-set.html