Re: Formatting SQL*Plus output..

cn_at_127.0.0.1 wrote:
>
> I am trying to create comma-seperated output from SQL*plus. It appears
> that all SQL*plus output must be "fixed width." Does anyone know how to
> create comma seperated columns via SQL*Plus without all of the whitespace
> between columns?
>

SQL> select empno||','||ename||','||job from emp;

EMPNO||','||ENAME||','||JOB

7839,KING,PRESIDENT
7698,BLAKE,MANAGER
7782,CLARK,MANAGER
7566,JONES,MANAGER
7902,FORD,ANALYST
7369,SMITH,CLERK
7499,ALLEN,SALESMAN
7521,WARD,SALESMAN
7654,MARTIN,SALESMAN
7788,SCOTT,ANALYST
7844,TURNER,SALESMAN
7876,ADAMS,CLERK
7900,JAMES,CLERK
7934,MILLER,CLERK