We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
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;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Draw The Triangle 2
You are viewing a single comment's thread. Return to all 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;