If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

oracle equivalent of REPEAT(String,integer)

I have to perform a task in oracle which involves using REPEAT kind of statement.
what is the oracle equivalent of REPEAT(String,integer)
in DB2
SELECT LENGTH(REPEAT('rr4', 5))
FROM SYSIBM.SYSDUMMY1;
this will return '15' as result,
the same thing i have to get in Oracle

This query will select the column 'name' and on this column repeat(padding,len) action should be performed

Despite your genuine attempt to confuse us, I think I understand what you are trying to achieve. You should try Oracle's RPAD function. By the way, asking this question in the Oracle forum might have been more productive.