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 tools available for managing mysql server? : Sql dba

0 Answers  

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

What are transaction and its controls?

0 Answers  

How to add, remove, modify users using sql?

0 Answers  

What is a null value?

0 Answers  

how to enter binary numbers in sql statements? : Sql dba

0 Answers  

What type of database is sql?

0 Answers  

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

what is the difference between where clause and having clause? : Sql dba

0 Answers  

What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,

What are different types of sql?

0 Answers