What is difference between SUBSTR and INSTR?

5 like 0 dislike

asked 1 year ago by marck_don (191,010 points)

1 Answer

1 like 0 dislike

Best 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 '-')

answered 1 year ago by daneim (127,080 points)

Related questions

4 like 0 dislike

1 answer

What is the return type of Instr and Strcmp?

asked 1 year ago by daneim (127,080 points)

5 like 0 dislike

1 answer

What is the difference between foreign key and reference key ?

asked 1 year ago by rad_joshep (19,390 points)

4 like 0 dislike

2 answers

What is the difference between the SQL*Loader and IMPORT utilities?

asked 1 year ago by marck_don (191,010 points)

9 like 0 dislike

1 answer

What is the difference between a return parameter and an OUTPUT parameter?

asked 1 year ago by eagles11 (179,830 points)

4 like 0 dislike

1 answer

What is the Difference between a post query and a pre query ?

asked 1 year ago by rad_joshep (19,390 points)