first: sorry for my bad english but ı hope ı will explain my problem.
ı have a value its including to many image names.
like this: some.jpganother.pngother.gifsomesome.jpg....
ı need to seperate this image names.
some.jpg
another.png
other.gif
somesome.jpg
ı am searching but still ı dont have enough answer.
my solutions are:
regexp_substr('some.jpganother.pngother.gif', '[a-z0-9/]+.jpg');
preg_match_all("@([a-z0-9-]+).(jpg|gif|png)@i",'some.jpganother.pngother.gif',$a);
thank you.