substr2 returns a portion of string, beginning at position, length characters long. substr2 calculates lengths using UCS2 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 substr2 are automatically converted to integers.