Sql query to increment the row value

User_X9S6M

'$'

I need sql query to print output like below

$

$$

$$$

for every row the length should be increment by 1

Alex Nuijten

select rpad ('$', rownum, '$')
 from dual
 connect by level <= 10

Alex Nuijten

select rpad ('$', rownum, '$')
 from dual
 connect by level <= 10

User_X9S6M

Thanks a lot @Alex Nuijten