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

Answer»

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.

Discussion