What are the two parts of a procedure ?
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.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between delete, truncate and drop command?
What is the least restrictive isolation level? : Transact sql
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Which operator is used in query for pattern matching?
what is the difference between a having clause and a where clause? : Sql dba
How is pl sql different from sql?
What do you mean by field in sql?
What is sqlerrd?
What is Histogram?
How to rename a table?
What is sql constant?
What is indexes?
When is a declare statement required?
How delete all data from all tables in sql?
What are all types of user defined functions?