SQL column formating

Giganews Newsgroups
Subject: SQL column formating
Posted by:  chua…@hotmail.com
Date: 18 Sep 2006

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

Replies