Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sqlplus spool option

Annamalai ASep 14 2011 — edited Sep 14 2011

Hi,

I'm spooling the sql query output from sqlplus with csv file format. the output file should have column name details. i set the heading on option but the below dotted line displayed in the second row of the csv file. can any one please help me how to skip that line bars from spool option.

SYSDATE TABLESPACE_NAME
--------- ------------------------------ ======> this line needs to be skip from csv file output. sorry if my question is basic one.

Thanks in Advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2011

Added on Sep 14 2011

#general-database-discussions

6 comments

1,253 views