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

basic sqlplus formatting. Its in one of the application developer guides on the oracle site. Here is what you do.

Basic Option

Set Linesize 2000

Or any number you choose. See if you can get it to work that way. If not do the following.

Column COLUMN_NAME Format asize

So for example if I want to set a column called CUSTOMERS to a certain size

Column CUSTOMERS format a20

It will be 20 pixels wide(I dont know what oracle uses to count this) If you are using a number column do not include the A in front of the number.

tpatel_at_rocketmail.com (Tejal) wrote in message news:<435a3888.0203140700.6ddf433f_at_posting.google.com>...
> When I execute queries in SQL/PLUS worksheet from Enterprise manager,
> the output I get in following format that is so hard to read.
> PROGRAMID
> 1
> ----------
> NAME
> --------------------------------------------------------------------------------
> DESCRIPTION
> --------------------------------------------------------------------------------
> REMOVED
> ----------
> COMMENTS
> --------------------------------------------------------------------------------
> 3
> ASDFGHJKLPOIUYTREWQZXCVBNASDFGHJKLPOIUYT
>
>
> PROGRAMID
> ----------
> NAME
> --------------------------------------------------------------------------------
> DESCRIPTION
> --------------------------------------------------------------------------------
> REMOVED
> ----------
> COMMENTS
> --------------------------------------------------------------------------------
> I was wondering if anyone know how do I setup so I can get my output
> in following format? Such as:
> ProgramID Name Description Removed Comments
> 1 Test Test <NULL> <NULL>
Received on Thu Mar 14 2002 - 13:53:16 CST