• + 0 comments

    SELECT ( SELECT LISTAGG('*', ' ') WITHIN GROUP (ORDER BY LEVEL) FROM dual CONNECT BY LEVEL <= outer_query.numt ) AS star_line FROM ( SELECT LEVEL AS numt FROM dual CONNECT BY LEVEL <= 5 ) outer_query;