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.
  1. Prepare
  2. SQL
  3. Alternative Queries
  4. Draw The Triangle 1
  5. Discussions

Draw The Triangle 1

  • TWiStErRob
     + 1 comment

    you can do this with 20 levels, just need the right padding size:

    select rpad('*', level*2, ' *') from dual
connect by level <= 20;

    or to flip the triangle:

    rpad('*', (20 - level + 1) * 2, ' *')