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 ])