SQL & PL/SQL

Hello to all ,

Having a strings like this, where pipe(|) is his delimiter

10:00 | x1 | 2 | RO | P | Con ausilio  | y1
10:10 | x2 | 1 | RO |  |  | y2
10:20 |x3 | 3 |  |  |  | y3
10:30 |x4 | 3 | RO | N | Con aiuto  | y4
10:40 |x5 | 1 | RO |  |  | y5
 
how can I break it up into columns, for example, the first char(before first pipe) insert in first variable, 
then, after first pipe,  second characters in a other column ans so on
 
col1 := '10:00';
 
col2 := 'x1';
col3 := '2';
col4:= 'RO';
col5 := 'P';
col6 := ' Con ausilio ';
col7 := 'y1';
 
 
col1 := '10:10';
col2 := 'x2';
.. and so on
 

thanks in advance