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.

Are stored procedures compiled?

926

---

Does view contain data?

1037

---

How can I speed up sql query?

962

---

how to extract a unit value from a date and time? : Sql dba

990

---

How do rank () and dense_rank () differ?

1046

---

What is sql constant?

1035

---

What does 0 mean in sql?

965

---

Is primary key an index?

991

---

What is partition by in sql?

1068

---

What are the 3 modes of parameter?

1154

---

Explain ttitle and btitle.

1119

---

Explain what is a column in a table?

1107

---

what are the differences between char and nchar? : Sql dba

1115

---

what are set operators in sql? : Sql dba

1054

---

how can we know the count/number of elements of an array? : Sql dba

1061

---