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 how can you save or place your msg in a table?

0 Answers  

---

What is dml and ddl?

0 Answers  

---

Why truncate is used in sql?

0 Answers  

---

Why commit is not used in triggers?

0 Answers  

---

What is the difference between stored procedure and view?

0 Answers  

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

0 Answers   Microsoft,

---

What do you mean by table in sql?

0 Answers  

---

What is the difference between joins?

0 Answers  

---

When is the explicit cursor used ?

0 Answers  

---

what are properties of a transaction? : Sql dba

0 Answers  

---

what are the security recommendations while using mysql? : Sql dba

0 Answers  

---

Is sql better than excel?

0 Answers  

---