Difference between SUBSTR and INSTR ?

INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

Interview Candidate
Sep 7th, 2004
4
2776

SQL Plus

Answer

Showing Answers 1 - 4 of 4 Answers

tarun1282
Profile Answers by tarun1282

Apr 27th, 2006

substr is used to get a sub part of a string but instr is a function that returns the position of a specific character and also according to it's occurence in that string.

rampratap409
Profile Answers by rampratap409 Questions by rampratap409

Dec 7th, 2006

substr is used to get a part of given string,
instr is used to search a charcter in the given string.
select substr(ename,1,3) three_charename, instr(ename,'A',1) a_present_at from emp;