Xref: alice comp.databases.oracle.misc:46607
From: Timothy M Kong <tmkong@acsu.buffalo.edu>
Newsgroups: comp.databases.oracle.misc
Subject: number leading zeros
Date: Thu, 11 Nov 1999 10:32:30 -0500
Organization: University at Buffalo (SUNYAB)
Lines: 12
Message-ID: <382AE18E.8A2BA336@acsu.buffalo.edu>
Reply-To: tmkong@buffalo.edu
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5-15 i686)
X-Accept-Language: en
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news.syr.edu!newsstand.cit.cornell.edu!news.acsu.buffalo.edu!acsu.buffalo.edu!not-for-mail

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?

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

I'm using Oracle 8

Thanks.
Tim K.
tmkong@buffalo.edu