SOaddict SOaddict - 1 year ago 79
SQL Question

How do I print a triangle of stars using SQL

Is it practically possible to create a triangle of stars like this as below in SQL.I know that this could be done easily in any other programming language like C,C++,Java but want to know whether it is really possible with just SQL or PL/SQL.I tried working on it with dual table in Oracle but couldn't get through it.

* *
* * * *
* * * or * * *

Can someone please shed somelight if anyone knows about it.

Answer Source

The simplest approach would be something like this. You can get more sophisticated particularly if you want to build the equilateral triangle rather than the right triangle.

SQL> ed
Wrote file afiedt.buf

  1  select rpad( '* ', level*2, '* ' )
  2    from dual
  3* connect by level <= 3
SQL> /

* *
* * *
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download