SQL> SELECT LPAD(RPAD('*', (CASE WHEN  LEVEL > 10 THEN 1 ELSE LEVEL END)   , '*'), 10) || RPAD(LPAD('*', (CASE WHEN LEVEL > 10 THEN 0 ELSE LEVEL - 1 END), '*'),10 ) FROM dual CONNECT BY LEVEL < 13;