Split string based on a key and delimiter

Question

I need to split a string based on a key in PL/SQL.

strCode:=empcode:empname:empcontactno;

strval:=101:John:9345723;

I have to write a generic function to split the strval based on the strCode and populate separate variables such var_empcode, var_empname,var_empcontactno for a bunch of records.

Split based on the delimiter is simple enough, but split based on key and populating corresponding variables is tricky, because the strCode is configurable and the function has to be generic to accomodate future changes in the strCode.

Kindly let me know if there is an easy way to work this one out. Thanks.

Use the Apex utility functions in Oracle. – Tim Biegeleisen Apr 20 '15 at 05:44 — Tim Biegeleisen, Apr 20 '15 at 05:44

score -1 · Answer 1 · edited Apr 20 '15 at 07:40

-1

For this you can use php explode() function.

<?php 
   $result = explode(':', Your_Array);
?>

this gives you an array like below

array(
  [0] =>empcode,
  [1] =>empname,
  [2] =>empcontactno
)

and you will get these value by using keys.

edited Apr 20 '15 at 07:40

Bruce_Wayne

1,564
3
18
41

answered Apr 20 '15 at 05:51

SuReSh

1,503
1
22
47

1

Why do yo thing a php answer would be appropriate to Oracle pl/sql question ? – user272735 Apr 20 '15 at 12:38
ok then please tell me how can we do this with sql? – SuReSh Apr 21 '15 at 04:43

Split string based on a key and delimiter

1 Answers1