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.

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

what is the difference between primary key and unique key? : Sql dba

0 Answers  

---

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers  

---

What is the command used to fetch the first 5 characters of a string?

0 Answers  

---

Where is all the data on the internet stored?

0 Answers  

---

Which command is used to call a stored procedure?

0 Answers  

---

Is postgresql a server?

0 Answers  

---

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

---

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

What is write ahead logging in sql server?

0 Answers  

---

Can we update views in sql?

0 Answers  

---