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: Correspondance of VB Val function

Re: Correspondance of VB Val function

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 25 Sep 2001 19:32:36 +0200
Message-ID: <tr1gfllaimdt1e@news.demon.nl>

"Oli" <SSI_95270_at_yahoo.fr> wrote in message news:720ded81.0109250542.73c5f1cd_at_posting.google.com...
> Hello,
> there is a function in VB call VAL allowing
> to retrieve only first numeric value of a string.
>
> E.g.
> A=75h87 Val(A)=75
> B=985 Val(B)=985
> C=9874R Val(C)=9874
> D=3Y87U Val(D)=3
>
> Does this function exist in PL/SQL ?
>
> Thanks

No

The sql reference manual would have told you that.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Sep 25 2001 - 12:32:36 CDT

Original text of this message

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