substrc returns a portion of string, beginning at position, length characters long. substrc calculates lengths using Unicode complete characters.

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 substrc are automatically converted to integers.