What is difference between SUBSTR and INSTR?
ORACLE Interview Questions and Answers (Part 3)
(Continued from previous question...)
519. What is difference between SUBSTR and INSTR?
SUBSTR returns a specified portion of a string eg SUBSTR('BCDEF',4) output BCDE
INSTR provides character position in which a pattern is found in a string. eg INSTR('ABC-DC-F','-',2) output 7 (2nd occurence of '-')
(Continued on next question...)
Other Interview Questions