Oracle Parse – Instr

pts.
Tags:
Database
IBM DB2
Oracle
SQL
I'm receiving a string pipe delimited I need to extract the data between pipes until the end of string. How do I do this? I currently have FUNCTION fParseValue (pValueMeters varchar2) return varchar2 is v_meter1 varchar2; begin v_meter1 := instr (pValueMeters, '|', 1, 1); v_meter2 := instr (pValueMeters, '|', 1, 2); v_meter3 := instr (pValueMeters, '|', 1, 3); return p_meter1 := substr(pValue, v_meter1, v_meter2 - v_meter1); return p_meter2 := substr(pValue, v_meter2, v_meter3 - v_meter2); end fParseValue; Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

To get two results back, use two functions, a function that returns a composite object (such as a record), or a procedure with two OUT parameters.

Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linkersystems.com)
800-315-1174 (+1-949-552-1904)

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dava19
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/oracle-parse-instr/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following