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.|