Answer Posted / chakri

Syntax of procedure :

CREATE OR REPLACE PROCEDURE proce_name (Arg list)
IS
LOCAL VARIBLE DECLARATION

BEGIN
----------
----------
---------
END;


In the about syntax

Up to IS key word called as Procedure Header and

Remaining Part is called as Procedure Body.

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

649

---

When is the explicit cursor used ?

597

---

What is the difference between row level and statement level trigger?

528

---

What are the two types of exceptions.

639

---

What is mutating table error?

671

---

---

Can we use threading in pl/sql?

523

---

What is the difference between inner join and natural join?

515

---

What do you mean by field in sql?

540

---

What is composite primary key in sql?

528

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1718

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

515

---

What are the constraints available in sql?

586

---

Differentiate between pl/sql and sql?

621

---

What are tables and fields?

597

---

Is sql microsoft?

552

---