Re: row width
Date: 1996/05/03
Message-ID: <318A26DB.20AB_at_clientlink.com>#1/1
It depends on how long you set the linesize. If the "set linisize xxx"
is not long enough to accomodate the entire select *, it will break into
multiple lines. Either define linesize big enough or adjust printable
column width.
1. set linisize 2000; or
2. column col_1_name format a20;
column col_2_name format 9999; etc.
Joseph Suh
DBA
ClientLink, Inc.
Kuo-Chien Kai wrote:
>
> Is there any way to make each long row a line in my select result ?
> For example, if I do
>
> sqlplus -s scott/tiger_at_t:myhost:ORCL <<+
> select * from emp ;
> exit
> +
>
> each row in the result will be broken into lines. How do I make
> each row a line ? I am new to Oracle. For Sybase I know I can use
> -w option to specify the row with.
> ---
> Best Regards,
>
> Kuo-Chien Kai
> ----------------------------------------------------------------
> Computer & Communication Center | E-mail: kckai_at_cc.nthu.edu.tw
> National Tsing Hua University | Phone: +886-35-715131-5160
> Hsinchu, Taiwan 30043 | Fax: +886-35-710776
Received on Fri May 03 1996 - 00:00:00 CEST