Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need the output display in Horizontal format in SQL/PLUS Worksheet in Oracle.
Ryan, it's like:
column column_name 'heading if|you want one' format a100 (the "a"
stands for an alphanumeric character)
...or for a number, like so
column column_name 'heading' format 99999 (will truncate your numeric
column to 5 spaces wide, displays ##### if your data is wider, though).
Ryan Gaffuri wrote:
>
> 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 - 21:49:40 CST