What are the two parts of a procedure ?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / guest

6 Answers
16305 Views
Hi Caliber IT, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the two parts of a procedure ?..

Answer / 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

What are the two parts of a procedure ?..

Answer / siddhartha

Declaration and executable

Is This Answer Correct ?

6 Yes

3 No

What are the two parts of a procedure ?..

Answer / kirankumar.vangeti

create or replace procedure procedure_name as

Declare
/* Declarative section: variables, types, and local sub
programs */
Begin
/* Executable section: Procedural and sql statements go
here */
Exception
/* exception handling section: error handling statements go
here */
End;

Is This Answer Correct ?

1 Yes

0 No

What are the two parts of a procedure ?..

Answer / ramesh

Procedure specification (spec)
Procedure body

Is This Answer Correct ?

0 Yes

2 No

What are the two parts of a procedure ?..

Answer / tulsi

Procedure Specification and Procedure Body.

Is This Answer Correct ?

6 Yes

9 No

What are the two parts of a procedure ?..

Answer / a.jyothsna

Procedure specification: create or replace procedure proc-nm
(agumentlist)
procedure body: is-------------end

Is This Answer Correct ?

2 Yes

5 No

Post New Answer