Folks,

I have a question here. I'd like to unload all rows from a table but when using unload command (as below), it does not include the header name as well (the columns name).

syntax :

unload to <filename>
select * from <tablename>

alternatively, I tried using select statement to select each column (for a test, table only constst of 3 columns..which is ok). and it does output the column name for each column selected. But, obviously, this is not practical for table with 50 columns for e.g.

so..anyone can share an idea?

Hi,

Please test with OUTPUT TO.

Gustavo.