Loading…

What is the difference between substr and instr function in Oracle?

S.no SUBSTR (sub-string) INSTR (in-string)
1. It extracts the specific part of the string from the whole string It searches the entire string for finding the sub-string
2. The output data type is the number for the numeric input and the character for the date and the character input The output data type is always the number
3. The second argument is always the number The second argument should be a number or the character depending upon the data type of the input.

Suggest An Answer

No suggestions avaliable!

Latest post from Oracle Interview Questions

Ask Question