Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: formatting output in sql window.
Try this:
column longcolumnname format a12 wordwrapped select longcolumnname from table_name where id=id;
Steve Raftery wrote:
>
> Can anyone help me out with formatting the output of queries in the sql
> window. Some character fields are too long to fit neatly on the screen
> so they wrap themselves around.
> like varchar2(200);
> I know there is a way to format the output something like this.
>
> select longcolumnname format A12 from table_name where id=id;
>
> Can someone give me a quick example of the correct syntax to do that.
>
> Thanks in advance.
>
> --
> Steve Raftery
>
> Webvision
> 19950 Mariner Avenue
> Torrance, CA 90503
> www.webvision.com
Received on Sat Mar 28 1998 - 00:00:00 CST