What is the difference between SUBSTR & INSTR functions?

Answer:

• SUBSTR function returns the sub-part identified by numeric values from the provided string.
  • For Example, [SELECT SUBSTR (‘India is my country, 1, 4) from dual] will return “Indi”.
• INSTR will return the position number of the sub-string within the string.
  • For Example, [SELECT INSTR (‘India is my country, ‘a’) from dual] will return 5.