Interested to Buy Any Domain ? << Click Here >> for more details...
What are the two parts of a procedure ?
- 6 Answers
- 15965 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 the max nvarchar size?
Can we insert data in view?
Is id a reserved word in sql?
What are data types in pl sql?
Why indexing is needed?
What is a sql statement?
Do we need to create index on primary key?
Can we create index on primary key?
How subquery works in sql?
Explain spool.
What does a pl/sql package consist of?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is cursor status?
What is the difference between the conventional and direct path loads? : aql loader
What is the difference between delete, truncate and drop command?
