Answer / swapnareddy

Declaration Block(optional)
Begin
Executable Block
exception Block(optional)
end;

Answer / manojbatra071

whenever we create stored procedure the syntax is:
CREATE OR REPLACE PROCEDURE proc_name
AS/IS
(declare variables inside this block)
BEGIN
perform whatever u want in stored procedure
EXCEPTION
(perform the steps if any errors occur than what to do )
END;

therefore the blocks are as/is , begin,exception and end

Answer / pronobesh

Actually there are 3 blocks
1) Declartion Block - Starts with AS right after CREATE
PROCEDURE <Proc Name>
2) Execution Block - Starts with BEGIN and ends with END
ahere the actual execution happen.
3) Exception Block - Where we catch the procedure error.

Hope this clarifies.

Answer / guest

Begin
--This section must contain atleast one executiable
statment.


Exception
end ;

Answer / sachin

create /alter proc nameof procedure
as/is
beging
statment
EXCEPTION
end

Answer / eshwer

Declaration block
Execution block
Exception block

What are the data types allowed in a table?

3 Answers  

What is the difference between truncate and drop statements?

0 Answers  

what are the limitations of identity column? : Transact sql

0 Answers  

Does sql use python?

0 Answers  

How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,

What are the different types of constraints?

0 Answers  

What is a subquery in sql?

0 Answers  

What is on delete restrict?

0 Answers  

Explain what is a database?

0 Answers  

Can we use ddl statements in stored procedure?

0 Answers  

How many disk partitions should I have?

0 Answers  

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,