Answer Posted / rao

we can utilise the space for record which is uesd to
truncate but delete we cant use same same space.

Why is there a need for sqlcode and sqlerrm variables?

581

---

What is sql profiling in oracle?

543

---

Can we perform dml in function?

592

---

How to return multiple rows from the stored procedure?

514

---

What is percent sign in sql?

713

---

---

Which one is better sql or oracle?

491

---

What is a stored procedure in sql with example?

598

---

What is the cause of mutating table error and how can we solve it?

594

---

How many triggers can be applied on a table?

503

---

how to use like conditions? : Sql dba

569

---

What is the purpose of the partition table?

540

---

Can one improve the performance of sql*loader? : aql loader

581

---

what is the difference between delete and truncate commands? : Sql dba

531

---

How do I run a query in pl sql developer?

556

---

what is dbms? : Sql dba

541

---