how to split strings in pl/sql | Oracle Community

I want to split p_def by dots, check for 3 elements, and return them in p_sch, p_table and ... Notes on Oracle: Splitting a comma delimited string the RegExp way.

community.oracle.com