SQL Plus - Column Headers

Suppress

• The system variable heading controls the visibility of the headers

-- will suppress the headers
set heading off

• The system variable pagesize will suppress the headers if it's set to 0.

To avoid this behaviour, you can add the embedded option.

set pagesize 0 embedded on

Separator

See SQL Plus - HEADSEP (heading separator character)