Question

1.Explain difference between substr and instr
function of SQL wih the help of example.​

Answer 1

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

Answer 2

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