Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: number leading zeros

Re: number leading zeros

From: Timothy M Kong <tmkong_at_acsu.buffalo.edu>
Date: Fri, 12 Nov 1999 10:30:20 -0500
Message-ID: <382C328C.D1F18258@acsu.buffalo.edu>


I've had two people help me with this. Just wanted to say thanks and sorry for posting such a dumb question. It's just that I have to use Oracle to get something done, I'm brand-new to this and I don't have access to the manual. :)

Tim

Timothy M Kong 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?
>
> 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_at_buffalo.edu
Received on Fri Nov 12 1999 - 09:30:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US