Answer / tulsi

SUBSTR is used to extract a set of characters from a string
by specificing the character starting position and end
position and length of characters to be fetched.
example substr('hello',2,3) will return 'ell'

INSTR is used to find the position of any particular
character in a word which returns numeric value.
instr('hello','e') - will return the position of 'e' as 2

Answer / 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

Answer / atchala ramanareddy

substr:
select substr('atchala ramanareddy',2,9) from dual;
it will return tchala ra.
instr:
select instr('atchala ramanareddy','a',1,2) from dual;
it will return 5.

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

What are types of exception?

0 Answers  

---

how to create object in plsql

2 Answers   TCS,

---

Explain alias in sql?

0 Answers  

---

how to return query output in html format? : Sql dba

0 Answers  

---

How do I delete a trigger?

0 Answers  

---

Can a foreign key be null?

0 Answers  

---

What is the maximum rows in csv?

0 Answers  

---

What is diff between bulk collect and forall

3 Answers   Metric Stream,

---

How do I truncate a word?

0 Answers  

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

how would you get the current date in mysql? : Sql dba

0 Answers  

---