Re: row width
Date: 1996/05/03
Message-ID: <4mbkqj$a3g_at_inet-nntp-gw-1.us.oracle.com>#1/1
kckai_at_cc.nthu.edu.tw (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 <<+
set linesize 1000
> select * from emp ;
> exit
> +
Use the set linesize instead of -w.
You might also consider:
> sqlplus -s scott/tiger_at_t:myhost:ORCL <<+ | sed 's/ *$//'
^^^^^^^^^^^^^^
set linesize 1000
> select * from emp ;
> exit
> +
To trim blanks.
>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
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
opinions and statements are mine and do not necessarily reflect the opinions of Oracle Corporation. Received on Fri May 03 1996 - 00:00:00 CEST