Splits the text according to each : character in the example:value:data variable. The result will be a table with 3 rows.

INSERT INTO movie (movie_title, category) VALUES ('The Avengers','action, superhero,fantasy'); INSERT INTO movie (movie_title, category) VALUES ('The Ring', 'horror ...

Does anyone know how I might split a string into an array in pl/sql? The kind folks at Oracle chose not to include that functionality in their language, and now I'm up a creek.<BR><BR>I need to split ...