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

How many sql core licenses do I need?

0 Answers  

What is %rowtype in pl sql?

0 Answers  

Is like operator in sql case sensitive?

0 Answers  

what is an index? : Sql dba

0 Answers  

Differentiate pl/sql and sql?

0 Answers  

What are code pages ?

1 Answers   BirlaSoft,

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  

What is oracle and pl sql?

0 Answers  

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

Is crud a cuss word?

0 Answers  

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,