REGEXP_REPLACE is a scalar function whose return value data type depends on the data type associated with source_string input parameter that is passed into the function.
| source_string Data Type | Result Type |
|---|---|
| CHAR, VARCHAR | VARCHAR in same character set as source_string |
| CLOB | CLOB in same character set as source_string |