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.

What is difference between sql and mysql?

1063

---

Can we create view in stored procedure?

908

---

Explain the insert into statements in sql?

934

---

What is integrity in sql?

979

---

what are sequences

1617

---

What are different types of triggers?

1024

---

What is example of database?

984

---

How can we debug in PL/SQL?

1089

---

How do I add a primary key to a table?

970

---

Why trigger is used in sql?

913

---

How do I view a sql trace file?

960

---

Is pl sql different from sql?

935

---

What is a Mapplet?

1057

---

Can we use having without group by in sql?

926

---

Can a table contain multiple foreign key’s?

947

---