Answer Posted / anil_abbireddy

A table is created with in the table is called nested table

Where is pl sql used?

948

---

Why is there a need for sqlcode and sqlerrm variables?

1046

---

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

1125

---

tell us something about heap tables. : Sql dba

1093

---

What are pl sql data types?

1007

---

how to escape special characters in sql statements? : Sql dba

1033

---

How do I upgrade sql?

998

---

Can we rollback truncate?

996

---

What is %rowtype in pl sql?

987

---

Why query optimization is needed?

921

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

968

---

Differentiate between % rowtype and type record.

1289

---

what is error ora-03113: end-of-file on communication channel?

1155

---

What is a constraint? Tell me about its various levels.

1156

---

What is sql table?

962

---