DEVFYI - Developer Resource - FYI

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