Difference between SUBSTR and INSTR?

Answer Posted / shrikant

Hi,
Yes Tulsi is right.
Execute the below queries & you will see the diff clearly -

SELECT instr('hello','e') FROM dual
SELECT substr('hello',2,3) FROM dual

Is This Answer Correct ?    34 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use sql constraints? Which constraints we can use while creating database in sql?

533


What is the main difference between sql and pl/sql?

552


What is nvarchar max in sql?

567


What is memory optimized table?

563


Is delete faster than truncate?

533






How do you modify a column in sql?

520


What is dml statement?

503


How many commands are in sql?

513


Is it possible to create the following trigger: before or after update trigger for each row?

707


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

794


What is a left join?

493


explain the difference between bool, tinyint and bit. : Sql dba

509


What is pivot in sql?

498


What is use of term?

605


what are integrity rules?

556