Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Val Function

510663May 17 2007 — edited May 17 2007
Unfortunately, I have been unable to find a PL/SQL function that is like Microsoft Access VAL function (accepts a string as input and returns the numbers found in that string).

Example: Val ("108S") would return 108

Any ideas?

Kelly
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2007
Added on May 17 2007
10 comments
4,125 views