I am working in Oracle 12cR2 and I want to know if there is any functionality in Oracle other than RPAD and LPAD that is the equivalent to REPLICATE of SQL Server, I need to obtain the function really equivalent to this, I have a case of difference which is the following :
SQL Server: SELECT REPLICATE ('HELLO', 0); Result = ''
Oracle: SELECT RPAD ('HELLO', LENGTH ('HELLO') * 0, 'HELLO') FROM DUAL; Result = NULL
I need to get the same result in both managers :( hope you can help me :(