Write a query to print stars

select lpad('*',level,'*') col from dual connect by level <= 5;

*

**

***

****

*****

select lpad('*',5-level+1,'*') col from dual connect by level <= 5;

*****

****

***

**

*

select lpad(' ',5-level,' ') || lpad('*',level,'*') col from dual connect by level <= 5;

    *

   **

  ***

 ****

*****

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

*****

 ****

  ***

   **

    *

select lpad('*',level,'*') col1,

        lpad('*',5-level+1,'*') col2,

        lpad(' ',5-level,' ') || lpad('*',level,'*') col3,

        lpad(' ',level-1,' ') || lpad('*',5-level+1,'*') col4

        from dual connect by level <= 5;