INSERT INTO Temp_Movie_Category(MovieID,categories,category_name)
select DISTINCT temp_movie.MovieID, temp_movie.movie_categories,
trim(regexp_substr(temp_movie.movie_categories, '[^|]+', 1, levels.column_value))
from
temp_movie,
table(cast(multiset(select level from dual connect by  level <= length (regexp_replace(temp_movie.movie_categories, '[^|]+'))  + 1) as sys.OdciNumberList)) levels;