SQL & PL/SQL

Hi,

I am using below query for finding minimum value.

select min(t) min_val

                          from

                          (SELECT (Regexp_Substr('7,8,10', '[0-9 ]+', 1, LEVEL)) t

                           FROM   Dual

                           CONNECT BY LEVEL <= Regexp_Count('7,8,10', ',') + 1);

The result is coming out to be 10 instead of 7 when I run this query.

Oracle database version is 12.1.0