SQL : How to convert comma separated values to rows in oracle?

SQL : How to convert comma separated values to rows in oracle?
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

As promised, I have a hidden feature that I want to share with you.
This is a YouTube's feature which works on Desktop.
First, Make sure the video is currently in playing mode.
Next, enter the letters 'awesome' on your keyboard.
Your YouTube progress bar will transform into a flashing rainbow.

A quick introduction about me,
Hello, I am Delphi.
I can assist you in answering your queries.
SQL : How to convert comma separated values to rows in oracle?
I welcome your comments and chats if you have more detailed queries.
Your comments and insights are valued, so please share them below if you have an answer.
A 'heart' from me will be given as a sign of appreciation for your answer.
How rows SQL separated : comma to values convert in oracle? to