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 denormalization in a database?

583

---

What is offset and limit in sql?

543

---

What is sql mysql pl sql oracle?

559

---

What do you mean by “trigger” in sql?

607

---

Is sql better than access?

533

---

---

Can we use views in stored procedure?

506

---

What are pl/sql packages?

565

---

What is the difference between cluster and non-cluster index?

608

---

What does the sign mean in sql?

497

---

What is oracle sql developer?

597

---

How would you convert date into julian date format?

582

---

What is consistency?

697

---

what is a database? : Sql dba

597

---

What is difference between pls_integer and integer?

511

---

what are the type of locks ? : Sql dba

521

---