Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> result format problem

result format problem

From: Jordan <mj_at_nba.com>
Date: Wed, 29 Aug 2001 01:22:53 +0800
Message-ID: <9mgjpf$p9i4@imsp212.netvigator.com>


Dear all,

            I have using join to produce the following result. However, there are too many title (deptno, deptno, empno, ename) for each four records and there are many space between each record. How can i produce more readable format? THANKS.

Jordan

    DEPTNO DEPTNO EMPNO ENAME
---------- ---------- ---------- ---------------

        10 20 7566 Jones

        20 20 7566 Jones

        30 20 7566 Jones

        40 20 7566 Jones

    DEPTNO DEPTNO EMPNO ENAME
---------- ---------- ---------- ---------------

        50 20 7566 Jones

        10 20 7788 Scott

        20 20 7788 Scott Received on Tue Aug 28 2001 - 12:22:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US