Oracle SUBSTR Function

Oracle SUBSTR (SubString | Sub String) function lets you extract a portion of string from a given string.

Syntax of Oracle SUBSTR function:

SUBSTR(string, position [, length ])

Parameter Description of Oracle SUBSTR Function:

Required parameter string can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB or NCLOB.

Required parameter position must be of datatype NUMBER or any datatype that can be implicitly converted to NUMBER.

Continue reading Oracle SUBSTR Function