SQL & PL/SQL

Hello,

Need to insert multiple rows at a time using a Stored Procedure.

The Front End will be Calling the SP by passing a input parameter which is a Varchar.
The input parameter has multiple rows with delimiters.

example:

create table Employee (ID integer,name varchar2,salary integer)

varvalue := '1,raj,2000|2,ramu,3000|3,ravi,4000'

Need to split this array and insert rows into the above table.

',' -> Column Delimiter
'|' -> Row Delimiter


select * from Employee

Output:

1 raj 2000
2 ramu 3000
3 ravi 4000



Thanks in Advance.