Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Preserve leading 0 in NUMBER columns ?

Preserve leading 0 in NUMBER columns ?

From: Jan-Olav Eide <janolav_at_nr.no>
Date: Tue, 22 Dec 1998 13:46:07 +0100
Message-ID: <367F948F.A24AAB77@nr.no>

I want to store, say, 03016536325 in a column, of type NUMBER (the leading 0 is significant). Can I do this or will I have to use VARCHAR2 ?

--
jo Received on Tue Dec 22 1998 - 06:46:07 CST

This message: [ Message body ]
Next message: Joel R. Kallman: "Re: Help on Alert Log Message"
Previous message: Michael Thompson: "ArcServer DBAgent for Oracle"
Next in thread: Thomas Kyte: "Re: Preserve leading 0 in NUMBER columns ?"
Reply: Thomas Kyte: "Re: Preserve leading 0 in NUMBER columns ?"
Reply: mpir_at_compuserve.com: "Re: Preserve leading 0 in NUMBER columns ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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