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 the difference between stored procedure and view?

0 Answers  

What is meant by temporal data?

0 Answers  

What are the ways on commenting in a pl/sql code?

0 Answers  

Can a procedure in a package be overloaded?

0 Answers   EXL,

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

How you will create Toad Function?

1 Answers  

What is a trigger in pl/sql?

1 Answers  

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

How to look at the current sql*plus system settings?

0 Answers  

Is pl sql still used?

0 Answers  

Do you know the basic structure of PL/SQL?

3 Answers