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 are the most important ddl statements in sql?

745

---

Can we use commit inside a trigger?

763

---

How to install oracle sql developer?

770

---

What is pl sql in oracle?

783

---

Differentiate between % rowtype and type record.

923

---

---

How does sql developer connect to oracle database?

737

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2176

---

What are tuples in sql?

775

---

Does sqlite need a server?

735

---

what are the differences between require and include, include_once and require_once? : Sql dba

743

---

how would concatenate strings in mysql? : Sql dba

740

---

What are the parameter modes supported by pl/sql?

731

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

735

---

How can I tell if sql is running?

761

---

what are the nonstandard string types? : Sql dba

803

---