Oracle SQL Question:
Explain What is difference between SUBSTR and INSTR?
Answer:
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 '-')
INSTR provides character position in which a pattern is found in a string. eg INSTR('ABC-DC-F','-',2) output 7 (2nd occurence of '-')
| Previous Question | Next Question |
| How to pass cursor variables in PL/SQL 2.2? | Explain What is an UTL_FILE.What are different procedures and functions associated with it? |