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

Thank you very much for your response. I tried what you told in the response but that didn't help either. any other ideas?

Thanks,
Tejal

Bricklen <bricklen_at_shaw.ca> wrote in message news:<3C916EAA.F6002A20_at_shaw.ca>...
> 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 Fri Mar 15 2002 - 10:25:32 CST