Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> result format problem
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