Answer Posted / 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 raw datatype in sql?

981

---

What are operators available in sql?

982

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1144

---

Mention what are different methods to trace the pl/sql code?

1108

---

What is hibernate and its relation to sql?

1068

---

What is sql exception?

915

---

What is execution plan in sql?

981

---

How do I filter in sql profiler?

949

---

What is a crud api?

903

---

What is trigger price?

926

---

What does count (*) do in sql?

954

---

What is difference between procedure and trigger?

919

---

Can a table have no primary key?

1011

---

what is subquery? : Sql dba

1068

---

What is numeric function sql?

988

---