Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Extracting values to right of strings? Regex?
Hello, oracle noob here.
I've got a function that returns a string that looks like this
Merchant Reference Code:610015
Request ID: 1877300000090176174087
Authorized Amount: 5.00
Authorization Code: 123456
Authorization Time: 2007-08-21T21:01:39Z
--- end
What's the best way in Oracle to return values for some of these strings?
for example, If the string contains the string "ACCEPT - " , set variable status to true, esle false
variable amount = numeric to the right of Authorized Amount, so amount = 5.00
Thanks for any help or information! Received on Tue Aug 21 2007 - 16:18:15 CDT