View original (French)

SQL*Plus and display of column headers

yaloum -  
 gege67 -
Hello, I’m looking to retrieve the column headers of a table (Fields) using SQL+, I tried with SET HEAD ON and SET HEADING ON, but to no avail. If anyone has faced the same requirement, I would be very grateful. Thank you 
Configuration: Windows XP Internet Explorer 6.0

3 answers

  1. gege67
     
    We must not have

    set pagesize 0

    this removes the titles posed by

    set heading on

    this is just to close this thread. So you should put for example

    set pagesize 100000
    set heading on

    in his sqlplus query.
    1