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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Table reading utility?

Re: Table reading utility?

From: Irene Westervelt <iwesterv-no_at_span.mdsi.bc.ca>
Date: 1998/03/11
Message-ID: <01bd4d39$f7d2bda0$a913f28a@pc354>#1/1

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

Original text of this message

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