Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL column formating

Re: SQL column formating

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 19 Sep 2006 08:02:10 -0700
Message-ID: <1158678128.814908@bubbleator.drizzle.com>


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 Group
Received on Tue Sep 19 2006 - 10:02:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US