Tag: oracle instring function

• May 25, 2012

  Oracle INSTR function

  Oracle INSTR function returns the position of the sub string string within a string. Function returns an integer value. It is an example of character functions. Syntax: INSTR(string, substring,[position],[place]) position and place are optional. INSTR can be used in PL/SQL too. Examples:- 1.select instr(‘sqlandplsql.com’,’.com’) as instrvalue from dual; INSTRVALUE ——————– 12 Returns the position of sub […]