Re: number leading zeros

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 11 Nov 1999 13:00:02 -0500
Message-ID: <AwQrOIFZAc9NMdp0CMK=50LLYH3J@4ax.com>

A copy of this was sent to Timothy M Kong <tmkong_at_acsu.buffalo.edu> (if that email address didn't require changing) On Thu, 11 Nov 1999 10:32:30 -0500, you wrote:

>Can somebody tell me how to make a number column display exactly nine
>digits, including leading zeros if the number is less than nine digits
>long?
>

select to_char( number_column, '000000009' ), ....

>I also need to know how to change column headings, for example, change
>LNAME to 'Last Name', etc

select lname "Last Name", .....

>
>I'm using Oracle 8
>
>Thanks.
>Tim K.
>tmkong_at_buffalo.edu

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Nov 11 1999 - 12:00:02 CST