I need to generate following pattern using sql
* * * * *
* * * *
* * *
* *
*
I tried below sql but not able to generate the spaces between stars
SELECT rpad('*',b.a,'*')
FROM
( SELECT level a FROM dual CONNECT BY level <= 5 ORDER BY level DESC
) b
*****
****
***
**
*