Re: result format problem

"Jordan" <mj_at_nba.com> wrote in message
news:9mgjpf$p9i4_at_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
>
>
>

Looks like What You Get is What You Ask. You need to look in setting the pagesize and linesize of your output, now it simply wraps because your output exceeds the default linesize. You also need to look at setting up appropiate column definitions. Please refer to the
set command
and the column command in your
sql*plus reference manual.
Alternatively you can consult Oracle 8i the complete reference by Kevin Loney
and/or the book on sql*plus by Jonathan Gennick. You'd better try to resolve these issues by reading docs, instead of having them resolved by the ng. Your questions are rather elementary, and having the ng resolve your problems doesn't teach you how to use sql*plus.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Aug 28 2001 - 15:00:49 CDT