Interested to Buy Any Domain ? << Click Here >> for more details...
What are the two parts of a procedure ?
- 6 Answers
- 16458 Views
- Hi Caliber IT, I also Faced
- E-Mail Answers
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
Name the different types of indexes in sql and define them.
How can we make an if statement within a select statement?
What are the different type of joins in sql?
Explain the difference between triggers and constraints?
Explain the working of primary key?
Can we join same table in sql?
What are sql injection vulnerabilities?
what is a table in a database ? : Sql dba
Do stored procedures prevent sql injection?
Is sql a programming?
What is t sql in sql server?
How to raise user-defined exception with custom sqlerrm ?
What is an invalid partition table?
how many groups of data types? : Sql dba
what are all the different types of indexes? : Sql dba
