Re: Need the output display in Horizontal format in SQL/PLUS Workshee t in Oracle.

Hi Norman,
Thank you for posting the answer. I tried the set linesize 1000
set trimspool on
and that didn't work. Then I set the wrap off but that cuts someo of my columns. The format data is displying is correct when I do that which I want but I am not able to see all of the columns data. For example, my table program has following fields Name, Desc, ID, Remove and I only see Name and Desc fields data in Horizontal which is correct format but i don't see Remove and ID columns data.
Any other suggestions?
If you could please reply me at tpatel_at_rocketmail.com that would be nice cause it's hard to find an answer in this group area.

Thanks in advance. I really appreciated a lot.

Thanks,
Tejal

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message news:<E2F6A70FE45242488C865C3BC1245DA70159294F_at_lnewton.leeds.lfs.co.uk>...
> You could try :
>
> set linesize 1000
> set trimspool on
>
> That way each line will be 1000 characters wide, and this should stop
> the wrapping.
> The trimspool bit simply means that if you spool the output to a file,
> SQLPlus will not space fill every line to 3000 characters wide.
>
> Another option is
>
> set wrap off which stops lines wrapping, but simply truncates output at
> the 'linesize' column.
>
>
> HTH
>
> regards,
> Norman.
>
> ------------------------------------------------------------------------
> -----
> Norman Dunbar EMail: Norman.Dunbar_at_LFS.co.uk
> Database/Unix administrator Phone: 0113 289 6265
> Fax: 0113 289 3146
> Lynx Financial Systems Ltd. URL: http://www.Lynx-FS.com
> ------------------------------------------------------------------------
> -----
Received on Fri Mar 15 2002 - 10:22:02 CST