You are viewing a single comment's thread. Return to all comments →
SELECT RPAD('* ', ((20*2)+1) - LEVEL*2, '* ') AS stars FROM dual CONNECT BY LEVEL <= 20;
Seems like cookies are disabled on this browser, please enable them to open this website
Draw The Triangle 1
You are viewing a single comment's thread. Return to all comments →
ORACLE SQL
SELECT RPAD('* ', ((20*2)+1) - LEVEL*2, '* ') AS stars FROM dual CONNECT BY LEVEL <= 20;