What are the two parts of a procedure ?
- 6 Answers
- 14846 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
What is orm in sql?
how to fetch alternate records from a table? : Sql dba
What is an implicit commit?
What is cursor status?
What is memory optimized table?
Is id a reserved word in sql?
Is it possible to create startup or shutdown trigger for on-schema?
What is basic structure of pl sql?
What are types of indexes in sql?
How many sql statements are used? Define them.
What is a pragma statement?
Explain spool.
What is the use of & in pl sql?
What are different joins used in sql?
What is multiple columns?
