Skip to Main Content

SQL & PL/SQL

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!

colsep not printing with break

552570Mar 15 2007 — edited Mar 19 2007
I'm formatting a sqlplus report that will get loaded into Excel.
When you set a BREAK on a column, the colsep doesn't get printed before the blank rows:

set colsep ','
break on zip on dealer

select zip, dealer, make from some_table;

ZIP , DEALER ,MAKE
-----, ----------, ----------
12345,DEALER A ,CHEVY
,BUICK

Notice on the second line, you don't get the comma between zip and dealer columns.

Any suggestions for getting the comma on each row?

Thanks,
Klaus
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2007
Added on Mar 15 2007
3 comments
412 views