Re: SQL column formating

chuaby_at_hotmail.com wrote:
> Hi
>
> this is the first time i am using Oracle PLSQL to produce a report, i
> know it's not the best but that's the option i have.
>
> Date/ String fields left justify their values and number right
> justifies it.
> i have a string field :
>
> Start Date
> =========
> 01-Jan-2001
> Jan-2001
> 2001
>
> May i know do i have to go to the extend using lpad to right justify
> this field ?
>
> Just to confirm there is no auto formating to resolve this simple
> alignment of field.
>
> Thank you
> Boon Yiang

Go to Morgan's Library at www.psoug.org and look up SQL*Plus and you will see demos on column formatting.

The docs can be found at http://tahiti.oracle.com

-- 
Puget Sound Oracle Users Group