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: How to put a Varchar into a Number?

Re: How to put a Varchar into a Number?

From: Philippe CEROU <philippe.cerou_at_free.fr>
Date: Wed, 09 Feb 2000 10:07:13 GMT
Message-ID: <l%ao4.147$k77.842838@nnrp3.proxad.net>


Try something like this :

MyNum := to_number(MyVar);

or

select to_number(MyVar) into MyNum from sys.dual;

:) Received on Wed Feb 09 2000 - 04:07:13 CST

Original text of this message

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