Re: Output Format Dilemma

set lines 100 (or whatever width you want) set pages 30

"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
>
> --
> N e w s N e t C u s t o m e r
> E - m a i l : sted.alana_at_hotmail.com
>
>
>
>
>
>
Received on Wed May 01 2002 - 23:20:25 CDT