Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Gotta Be Simple PL/SQL
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