Output Format Dilemma

From: Sted Alana <Sted_Alana_at_hotmail.com>
Date: Wed, 01 May 2002 10:37:04 GMT
Message-ID: <3ccfc4d7_1@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 - 05:37:04 CDT