SQL column formating

From: <chuaby_at_hotmail.com>
Date: 18 Sep 2006 20:01:33 -0700
Message-ID: <1158634893.454440.278780@i3g2000cwc.googlegroups.com>

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 Received on Mon Sep 18 2006 - 22:01:33 CDT