Answer Posted / raji_4u

1. Anonymous blocks are compiled each time they are executed,
where as stored subprograms compile only one time when they
are created.

2. Anonymous blocks are not stored in the database so they
can not be called from other blocks, where as stored
subprograms are stored in the database they can be called
from other blocks many times.

How many subqueries can be nested in a statement?

977

---

What is indexes?

1052

---

Is drop table faster than truncate?

984

---

What information is needed to connect sql*plus an oracle server?

1018

---

Explain what is a column in a table?

1097

---

What is the difference between a primary key and a clustered index?

980

---

How can I see all tables in sql?

1060

---

how to analyze tables with 'mysqlcheck'? : Sql dba

1004

---

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..

2487

---

How to read/write files from pl/sql?

1030

---

How do I make my sql query run faster?

933

---

Why do we use sqlite?

962

---

Can unique keys be null?

894

---

Can cursors be part of a trigger body?

1633

---

What is null in pl/sql?

1058

---