Oracle SQL - Print Different Star Pattern using connect by query

In this post, I explained how to print different start pattern. 

 SELECT LPAD(CHR(32), 5 - LEVEL, CHR(32))||LPAD('*', LEVEL, '*') stars
   FROM DUAL
CONNECT BY LEVEL <= 5
  UNION ALL
 SELECT LPAD(CHR(32), LEVEL, CHR(32))||LPAD('*', 5 - LEVEL, '*') stars
   FROM DUAL
CONNECT BY LEVEL < 5

SAMPLE OUTPUT:

STARS

---------

    *
   * *
  * * *
 * * * *

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

Refer image to print Parameterized Star

 SELECT LPAD(CHR(32), :P_MAX_LEVEL - LEVEL, CHR(32))||LPAD('*', LEVEL, '*') stars

   FROM DUAL
CONNECT BY LEVEL <= :P_MAX_LEVEL
  UNION ALL
 SELECT LPAD(CHR(32), LEVEL, CHR(32))||LPAD('*', :P_MAX_LEVEL - LEVEL, '*') stars
   FROM DUAL
CONNECT BY LEVEL < :P_MAX_LEVEL

Thanks & Regards

R. Kalaiyarasan

+91 9944809554