SPLIT Question

[nrkotha]

Hi,

I have a string like A#B#C, This string in the PL/SQL block, I want to split where the # sign and return the 3 values from my procedure OUT parameters.

I am poor in the SQL, If any one know how to split this string to 3 different varaible, plase let me know.

I want something like this:
StrABC = A#B#C

StrA = A
StrB = B
StrC = C

Thanks in advance,
Raju

[nrkotha]

Never Mind,

I got the answer, Here is the sql if any one need:

select name,
substr(name,
instr(name,'#')-1,
instr(name,'#')-1
) ,
substr(name,
instr(name,'#')+1, --start with
instr(name,'#',1,2)-(instr(name,'#')+1) --End With
),
substr(name,
instr(name,'#',1,2)+1
)
from EMP;