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.

Does sql between include endpoints?

566

---

What is union and union all keyword in sql?

574

---

Can two tables have same primary key?

540

---

How do you use a while loop in pl sql?

547

---

how to use like conditions? : Sql dba

592

---

---

how to convert character strings to numeric values? : Sql dba

590

---

What is the use of sqlerrd 3?

533

---

what is single byte over head in oracle..?

1884

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

553

---

What do you mean by stored procedures?

560

---

Explain cursor types?

592

---

explain mysql aggregate functions. : Sql dba

556

---

Does sql full backup truncate logs?

541

---

what is a database? : Sql dba

614

---

What is output spooling in sql*plus?

564

---