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 is sql and its types?

1 Answers  

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1 Answers   MCN Solutions,

What is the non-clustered index in sql?

1 Answers  

How do I run a sql script?

1 Answers  

What is a left inner join?

1 Answers  

What is row_number () in sql?

1 Answers  

what is autonomouse transaction?

3 Answers   Oracle,

What are the different types of joins in sql?

4 Answers  

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

1 Answers  

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

Write a query to get last 10 records from the table.

12 Answers   iNautix,