Answer Posted / sachin fulari

In Layman tounge -
---------------
Whenever any named block in PL/SQL is created using CREATE
OR REPLACE clause, and as we compile it will get stored in
database, henceforth other code snippets can call/use this
block which ulimately resides in database after creation
i.e. "stored in database". And thus will move along
database if ever we move the database.


In oracle way -
---------------

A stored procedure is created and stored in the database as
a schema object. Once created and compiled, it is a named
object that can be run without recompiling. Additionally,
dependency information is stored in the data dictionary to
guarantee the validity of each stored procedure.

Is sql a scripting language?

1081

---

What is view? Can we update view

1513

---

How to read xml file in oracle pl sql?

943

---

What are % type and % rowtype?

1075

---

What are hotfixes and patches?

986

---

How can you load microsoft excel data into oracle? : aql loader

1213

---

How do temporal tables work?

1017

---

What is database sql?

1092

---

what is the use of set statement in tsql? : Transact sql

1058

---

What does rownum mean in sql?

1087

---

Why do we use joins in sql?

1004

---

List and explain the different types of join clauses supported in ansi-standard sql?

1400

---

Can we delete column in sql?

1165

---

How do I audit the sql sent to the server?

1053

---

How can I tell if sql is running?

1126

---