1.Explain difference between substr and instr
function of SQL wih the help of example.
Answers
Answered by
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. ...
Answered by
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 .
Similar questions