Parse through a string in PL/SQL

Hi!

How can I parse through a string in PL/SQL and assign different parts of the string to variables?

E.g. given string: "Jeff,Volberg,500 Oracle Parkway"

How can I go through the string and assign "Jeff" to the variable first_name (i.e. from the beginning to the first comma)? Then continue after the first comma (until I hit the next comma) and assign that part of the string (Volberg) to the variable last_name. And finally assign the text after the last comma (until the end of the input string) to the variable address?

Any idea?

Thanks,
Helmut

PS: This is 8.1.6 on Win2k. Received on Mon Nov 27 2000 - 15:40:32 CST