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.

what is a database lock ? : Sql dba

0 Answers  

---

What is the use of double ampersand (&&) in sql queries? Give an example

0 Answers  

---

What is bind reference and how can it be created?

0 Answers  

---

What is meant by user defined function?

0 Answers  

---

What is pragma in pl sql?

0 Answers  

---

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

---

What is the use of pl/sql table?

0 Answers  

---

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

What are the types of views in sql?

0 Answers  

---

Which sql statement is used to return only different values?

0 Answers  

---

What is view? Can we update view

0 Answers  

---

Enlist the characteristics of pl/sql?

0 Answers  

---