Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What are the blocks in stored procedure?

Answers were Sorted based on User's Feedback



What are the blocks in stored procedure?..

Answer / swapnareddy

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

Is This Answer Correct ?    15 Yes 3 No

What are the blocks in stored procedure?..

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

Is This Answer Correct ?    11 Yes 2 No

What are the blocks in stored procedure?..

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.

Is This Answer Correct ?    3 Yes 0 No

What are the blocks in stored procedure?..

Answer / guest

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


Exception
end ;

Is This Answer Correct ?    3 Yes 2 No

What are the blocks in stored procedure?..

Answer / sachin

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

Is This Answer Correct ?    0 Yes 0 No

What are the blocks in stored procedure?..

Answer / eshwer

Declaration block
Execution block
Exception block

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How do I run a sql script?

0 Answers  


What is the difference between having and a where in sql?

0 Answers  


What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  


please explain database architecture..

1 Answers   Infosys,


when normalization is required

3 Answers   HCL,


What is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  


What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,


how is exception handling handled in mysql? : Sql dba

0 Answers  


What is the use of %rowtype?

0 Answers  


What are all the difference between Like and Contains ?

2 Answers   LG Soft,


What are the different types of functions in sql?

0 Answers  


What is an Integrity Constraint?

4 Answers  


Categories