Answer Detail: RE: What is difference between SUBSTR and INSTR?</div><div>

GeekInterview.com > Interview Questions > Oracle > SQL

Print |

Question: 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 '-')

July 07, 2005 11:34:04	#1
ss	Member Since: Visitor Total Comments: N/A
RE: What is difference between SUBSTR and INSTR?
substr('BCDEF',4)=EF