Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table reading utility?
You can make use of reportwriter or use some sqlplus commands
columns [column name] format a10
set space 1 etc
James Ching <siuc_at_earthlink.net> wrote in article
<3503A966.92877847_at_earthlink.net>...
> Sorry for this newbie question. I'm using SQL*Plus for unix.
> I wonder if there is a utility to show records in a table better.
> Currently if a table contains more attrs than a screen can display,
> sqlplus
> breaks one record into multiple lines, which is extremely unreadable.
>
> I wonder if there is any environment variable I can set, or a totally
> different utility I can use to display records better.
> Say, instead of ,
>
> attr1 attr2 ...
> ----- -----
> val1 val2
>
> attn
> ----
> valn
>
> it displays,
>
> attr1 val1
> attr2 val2
> ...
> attrn valn
>
> Thanks
>
> James Ching
> EarthLink Network, Inc.
>
Received on Wed Mar 11 1998 - 00:00:00 CST
![]() |
![]() |