REGEXP_SUBSTR 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.
A source_string of the following:
| source_string Data Type | Return Type |
|---|---|
| CHAR, VARCHAR | VARCHAR in same character set as source_string |
| CLOB | CLOB in same character set as source_string |