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 -> Gotta Be Simple PL/SQL

Gotta Be Simple PL/SQL

From: Joe <heltibrand_at_NO_SPAMkarpel.com>
Date: Fri, 30 Apr 2004 14:42:22 -0500
Message-ID: <1095b1858dp2465@corp.supernews.com>


Hi all

    OK, I feel embarresed.

    What is the simplest way to pick a number out of a string, i.e. 'Bill is 35 today' should return 35. I'm thinking some combination of substr and instr.

    Any thoughts? Any nice thoughts, at least?

Joe Received on Fri Apr 30 2004 - 14:42:22 CDT

Original text of this message

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