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.

Have you tried to increase linesize? Syntax:

set linesize 100

Standard linesize is 80 in sqlplus.

>
> 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
Received on Wed May 01 2002 - 10:20:14 CDT