INTERVIEW QUESTIONS ORACLE SQL IN ORACLE DETAILS

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

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 '-') Source: CoolInterview.com

select substr('abcde',4) gives the output as
de because it counts quotation also as a string so it eliminates till 4 char i.e('abc)and gives the output as above

select instr('abcde',4) gives the output as 0 Source: CoolInterview.com

# 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 '-') Source: CoolInterview.com

SUBSTR:-
returns a specified portion of a string
eg:- SUBSTR('GANGAA',5)
->output GANGA
INSTR:-
provides character position
found in a string. eg INSTR('KHAIRATABAD','A',3)
->output 8 (3RD occurrence of 'A')
Source: CoolInterview.com

substring is used to return the portion of the string
eg:substr('str',2)
output is :ta
it will start count from the single quotation

instr is used to return the position of the mentioned string
eg: instr('sta','a')
output is : 3
It wont start it count from single quotation
Source: CoolInterview.com

substring is used to return the portion of the string
eg:substr('str',2)
output is :tr
it will start count from the single quotation

instr is used to return the position of the mentioned string
eg: instr('sta','a')
output is : 3
It wont start it count from single quotation
Source: CoolInterview.com

Substr retrieves the string at the required position as Instr retrieves the string position only Source: CoolInterview.com

SUBSTR returns a specified portion of a string eg SUBSTR('BCDEF',4) output is EF But
INSTR provides character position From where we start searching in a string eg. INSTR('ABCDAESVFDCNCW','C',1,2) the output will be 11.. The syntex is INSTR('The String','The character we want to search'the starting position of searching,Occurrence of that character) ... Source: CoolInterview.com

most of member provided wrong answer here regarding SUBSTR.this is correct please efer it.

SUBSTR('abcde'2)
output:bcde

SUBSTR('abcde',2,3)
output:bcd Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question