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 the difference between function, procedure and package in pl/sql?

1245

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2165

---

Is subquery faster than join?

1009

---

What is the current version of postgresql?

1060

---

What is indexing in sql and its types?

1076

---

What are the three forms of normalization?

1042

---

How is pl sql different from sql?

1082

---

Which sql most popular?

983

---

Explain spool.

1175

---

Can we use joins in subquery?

1156

---

What is the purpose of the partition table?

1046

---

What is difference between stored procedure and trigger?

1159

---

What is sql used for?

1117

---

How to add new employee details in an employee_details table with the following details

1085

---

What is mdb stand for?

1005

---