Star Pattern by SQL in Oracle Database

Star Patterns by SQL in Oracle -

nimish@garg> select lpad('*',level,'*') from dual connect by level <= 5;

LPAD('*',LEVEL,'*')
---------------------------------------------------------------------------------

*
**
***
****
*****


nimish@garg> select lpad('*',5-level+1,'*') from dual connect by level <= 5;

LPAD('*',5-LEVEL+1,'*')
---------------------------------------------------------------------------------

*****
****
***
**
*


nimish@garg> select lpad(' ',5-level,' ') || lpad('*',level,'*') from dual connect by level <= 5;

LPAD('',5-LEVEL,'')||LPAD('*',LEVEL,'*')
------------------------------------------------------------------------------------------------------

    *
   **
  ***
 ****
*****


nimish@garg> select lpad(' ',level-1,' ') || lpad('*',5-level+1,'*') from dual connect by level <= 5;

LPAD('',LEVEL-1,'')||LPAD('*',5-LEVEL+1,'*')
---------------------------------------------------------------------------------------------------------

*****
 ****
  ***
   **
    *
    
    
nimish@garg> select lpad('*',5-level+1,'*') || lpad('*',level*2-1,' ') || lpad('*',5-level,'*') star_pattern
  2  from dual connect by level <= 5
  3  union all
  4  select lpad('*',level,'*') || lpad('*',(5-level)*2+1,' ') || lpad('*',level-1,'*')
  5  from dual connect by level <= 5;

STAR_PATTERN
-----------------------------------------------------------------------------------------------------------------

**********
****  ****
***    ***
**      **
*        *
*        *
**      **
***    ***
****  ****
**********

10 rows selected.

nimish@garg> select lpad(' ',5-level+1,' ') || lpad('*',level*2-1,'*') diamond
  2  from dual connect by level <= 5
  3  union all
  4  select lpad(' ',level+1,' ') || lpad('*',(5-level)*2-1,'*') diamond
  5  from dual connect by level <= 5;

DIAMOND
-----------------------------------------------------------------------------------------------------------------

     *
    ***
   *****
  *******
 *********
  *******
   *****
    ***
     *

10 rows selected.

Related Posts - 

- SQL Puzzle - Calendar of Current Year 

- SQL Puzzle - Grouping Deals 

- SQL Puzzle - Sorting Versions stored in Varchar2 Column 

- SQL Puzzle - Transpose Rows and Shift Values among columns 

- SQL Puzzle - Consecutive Wins 

- Diamond Shaped Star Pattern by SQL 

- Graph Shortest Path Solution by SQL