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 low level language?

1004

---

What do you understand by pl/sql cursors?

1071

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1246

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4001

---

What are the types of variable use in pl sql?

1056

---

How do I save the results of sql query in a file?

963

---

What is dml statement?

938

---

Is inner join faster than left join?

1172

---

How do you explain an index number?

1080

---

What is #table in sql?

1068

---

Which join is like inner join?

1006

---

What is procedure explain with program?

996

---

What is a pdo connection?

1008

---

how many triggers are allowed in mysql table? : Sql dba

1041

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

955

---