Oracle Database 19c
Windows environment.
I have a string for example str1 = 'file1.jpg,file2.JPG-file3.png-file4.jpeg,filename5.PNG'
The string might be comma separated or any other character.
I want to extract the file name from the string as follows:
file1.jpg
file2.JPG
file3.png
file4.jpeg
filename5.PNG
I need the output in PLSQL program.
Thanks