Question: what is the difference between substr and instr functions?
Answer: INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence. SUBSTR calculates lengths using characters as defined by the input character set. ...