Tag: oracle instring function
-
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 […]