Oracle Parse – Instr
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
Software/Hardware used:
Software/Hardware used:
ASKED:
November 15, 2006 9:59 AM
UPDATED:
November 15, 2006 10:48 AM
Answer Wiki:
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)
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
