Experts Exchange connects you with the people and services you need so you can get back to work.
Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.
create or replace procedure myproc(p_str in varchar2)
for i in (
select mystr from (
select rtrim(regexp_substr(p_str,'([[:alnum:]]*)(,)?',1,column_value),',') mystr
multiset(select level from dual connect by level <= ((length(p_str)-length(replace(p_str,','))))+1)
dbms_output.put_line('Got: ' || i.mystr);
Open in new window
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.
Premium members get this course for $62.50.
Premium members get this course for $174.99.
Premium members get this course for $151.20.
Premium members get this course for $12.50.
Premium members get this course for $299.99.