SQL Plus - Column Headers

1 - About

Column header management

3 - Management

3.1 - 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

3.2 - Separator

See SQL Plus - HEADSEP (heading separator character)

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap