Posts Tagged ‘Oracle Functions’

Oracle SUBSTR Function

March 28th, 2012 No comments

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.

Read more…

Categories: Oracle Tags: