PLSQL split words with delimiter by only one SQL Command

PLSQL split words with delimiter by only one SQL Command
Often, when you need to substr in to rows of table or in to array  you tend to think of function substr,instr.
This example will show you for only one SQL command to solve this case

Example 1 Split words in to rows of table with SQL query
SELECT substr(main_string, position_from + 1, position_to - position_from - 1)
FROM (SELECT main_string,
decode(rownum - 1, 0, 0, instr(main_string, ',', 1, rownum - 1)) position_from,
instr(main_string, ',', 1, rownum) position_to
FROM (SELECT 'PLSQL1,PLSQL2,PLSQL3,PLSQL4,' main_string
FROM dual)
CONNECT BY LEVEL <= length(main_string))
WHERE position_to > 0
Note for this case
 in the end of str_string need end delimiter

FROM (SELECT 'PLSQL1,PLSQL2,PLSQL3,PLSQL4,' main_string

If you need to count the word you can try that
select count(*) from (
SELECT substr(main_string, position_from + 1, position_to - position_from - 1)
FROM (SELECT main_string,
decode(rownum - 1, 0, 0, instr(main_string, ',', 1, rownum - 1)) position_from,
instr(main_string, ',', 1, rownum) position_to
FROM (SELECT 'PLSQL1,PLSQL2,PLSQL3,PLSQL4,' main_string
FROM dual)
CONNECT BY LEVEL <= length(main_string))
WHERE position_to > 0
)