Re: SQL column formating

From: <chuaby_at_hotmail.com>
Date: 19 Sep 2006 09:10:45 -0700
Message-ID: <1158682245.112168.6310@k70g2000cwa.googlegroups.com>

>
> What version of Oracle and can you show us a sample of the data?

I am using Oracle 8i. My data is stored as string.

Start Date

01-Jan-2001
Jan-2001
2001

right justified. But currently, i am using lpad to push the data to the left to become

Start Date

01-Jan-2001

     Jan-2001
           2001

so that it is easier to read.

So, i have a problem of formating it without using lpad. But by using lpad, the oracle gives the error "sort not in order" which requires me to remove some function.

so, i am trying to look for a cleaner formating solution. Thank you in advance for any advice.

Best Regards
Boon Yiang Received on Tue Sep 19 2006 - 11:10:45 CDT