Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL column formating
chuaby_at_hotmail.com wrote:
> Hi
>
> thank you very much for the info. In fact, i have read the oracle
> document on SQL*Plus , which is the similar to the info in Morgan's Lb
> but could not find a solution.
>
> I got the column format, but my objective is to right justify "string"
> column. I cannot use a generic DATE format as i do not have complete
> date info in some rows. as such, i have to store the date field as
> "CHAR" rather than DATE.
>
> Thank you
> Boon Yiang
What version of Oracle and can you show us a sample of the data?
-- Daniel Morgan Puget Sound Oracle Users GroupReceived on Tue Sep 19 2006 - 10:02:10 CDT
![]() |
![]() |