Re: Output Format Dilemma

"Sted Alana" <Sted_Alana_at_hotmail.com> wrote in message news:<3ccfc4d7_1_at_news.iprimus.com.au>...
> Oracle 8i / sql*plus
>
> Problem: DEPTNO column wraps to next line - see below.
>
> Someone suggested to increase buffer size, but that does not fix the problem
> as it adds height but not width, which is what i probably need in this case.
>
> Any help appreciated.
>
>
> =====================
> select * from emp;
>
> EMPNO ENAME JOB MGRNO HIREDATE SAL COMM
> ---------- ---------- ---------- ---------- --------- ---------- ----------
> DEPTNO
> ----------
> 7839 alan trainer 17-NOV-93 5000
> 10
>
> 7698 larry trainer 7839 01-MAY-95 3000
> 30
>
> 7782 richard trainer 7839 09-JUN-97 4200
> 10
>
> 7566 dean trainer 7839 02-APR-97 3200
> 40
>
> 7654 mike salesman 7698 28-SEP-92 3300 3500
> 30
>
> 7499 jim salesman 7698 20-SEP-93 1600 1000
> 30
>
> EMPNO ENAME JOB MGRNO HIREDATE SAL COMM
> ---------- ---------- ---------- ---------- --------- ---------- ----------
> DEPTNO
> ----------
>
> 7844 jean salesman 7698 08-SEP-93 1500 0
> 30
>
> 7900 james programmer 7698 03-DEC-95 3500 0
> 30
>
> 7521 jill salesman 7698 22-FEB-95 2300 500
> 30
>
> 7902 harry analyst 7566 03-DEC-97 3000
> 40
>
> 7369 anne programmer 7902 17-DEC-96 1200
> 20
>
> 7788 kim analyst 7566 09-DEC-96 3000
>
> EMPNO ENAME JOB MGRNO HIREDATE SAL COMM
> ---------- ---------- ---------- ---------- --------- ---------- ----------
> DEPTNO
> ----------
> 20
>
> 7876 adam programmer 7788 12-JAN-98 3100
> 20
>
> 7934 tim programmer 7782 23-JAN-98 4500
> 10

It looks to me that the DEPTNO column is not wrapping due to the size of the value but rather due to the length of the (output) line. Try setting the linesize longer than 80. On most screens the line will still wrap around but for spooled files all the data will appear on one line.

set linesize 132

HTH -- Mark D Powell -- Received on Wed May 01 2002 - 08:55:04 CDT