substr returns a portion of string, beginning at position, length characters long. substr calculates lengths using characters as defined by the input character set.
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 substr are automatically converted to integers.