SQL & PL/SQL

Hi,

I have a string held in a column as below:

'product~P1$department~D1$company~C1'

I need to split this string into individual values as below:

P1

D1

C1

product, department and company are static parts of the string but can occur at any position within string ie.

'product~P1$department~D1$company~C1'

OR

'department~D1$product~P1$$company~C1'

OR

'company~C1$product~P1$department~D1'

etc...

I know INSTR and SUBSTR can do the job.

However need advise if more optimized and performance way to achieve it.