Oracle/PLSQL: Instr Function

Oracle/PLSQL > Functions > Instr

Instr function returns the location of a substring in a string.

The syntax for the instr Oracle function is:

instr( string1, string2 [, start_position [, nth_appearance ] ] )

Example

select INSTR('test', 'e') from dual

result:
2