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.

Answer / siddhartha

Declaration and executable

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;

Answer / ramesh

Procedure specification (spec)
Procedure body

Answer / tulsi

Procedure Specification and Procedure Body.

Answer / a.jyothsna

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

What is database sql?

0 Answers  

Can we connect to postgresql using sql developer?

0 Answers  

Why is pl sql needed?

0 Answers  

What is trigger point?

0 Answers  

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

What is nvarchar max in sql?

0 Answers  

What is set serveroutput on?

0 Answers  

What is output spooling in sql*plus?

0 Answers  

Can a select statement fire a trigger?

0 Answers  

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

What are data types in pl sql?

0 Answers  

Which join is like an inner join?

0 Answers