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:
- CHAR, VARCHAR returns VARCHAR in the same character set as source_string.
- CLOB returns CLOB in the same character set as source_string.