Build pattern for Regex

I am using sqldevelopper and I have those situations
" First";“Second3”; “Third4”;“Fourth”; 7
And
First;Second; Third ;Fourth; 7

I using SQL developer and tried something like this

For the first I tried Regex_substr('sentence ´, ´;(.*?);´ , 1, 1 , ´´, 1) But I can’t get Third or the last value

All I need is a pattern to retrieve values distinctly without " or ;

Could you help please

SELECT DISTINCT TRIM(BOTH '" ’ FROM REGEXP_SUBSTR(your_column, ‘[^;"]+’, 1, level))
FROM your_table
CONNECT BY PRIOR DBMS_RANDOM.VALUE IS NOT NULL
AND REGEXP_SUBSTR(your_column, ‘[^;"]+’, 1, level) IS NOT NULL
AND PRIOR SYS_GUID() IS NOT NULL;

Cheers… @Mlleella

Hi @Mlleella

Try this:

SELECT DISTINCT REGEXP_SUBSTR('sentence', '[^";]+', 1, LEVEL) AS extracted_value
FROM dual
CONNECT BY REGEXP_SUBSTR('sentence', '[^";]+', 1, LEVEL) IS NOT NULL;

Hope it helps!!