Oracle: What is difference between SUBSTR and INSTR?

+1 vote

572 views

posted Feb 12, 2015 by Kali Mishra

Share this question

Your comment on this post:

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.

0 votes

SUBSTR returns a specified portion of a string.
INSTR provides character position From where we start searching in a string

answer Feb 13, 2015 by Arun Gowda

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.

Email me at this address if my answer is selected or commented on:Email me if my answer is selected or commented on

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.