Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Correspondance of VB Val function
"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