substr4 returns a portion of string, beginning at position, length characters long. substr4 calculates lengths using UCS4 codepoints.
string can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The return value is the same datatype as string. Floating-point numbers passed as arguments to substr4 are automatically converted to integers.