Declaration Block(optional) Begin Executable Block exception Block(optio

What are the blocks in stored procedure?

Question Posted / swapnareddy

Answer Posted / swapnareddy

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

Is This Answer Correct ?

15 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is an example of translating a date into julian format?

1117

what is error ora-03113: end-of-file on communication channel?

1163

What does pl sql developer do?

924

Can two tables have same primary key?

976

How do you delete data from a table?

1036

What is set serveroutput on?

1136

What does where 1 1 mean in sql?

1040

Which version of sql do I have?

1056

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2571

Are subqueries better than joins?

975

which operator is used in query for pattern matching? : Sql dba

1005

What is clause in sql?

1108

Is left join same as join?

993

Which join condition can be specified using on clause?

952

How to install oracle sql developer?

1042