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

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3099

Explain raise_application_error.

1141

How to return an array from java to pl/sql?

1177

How does a covering index work?

1008

What is a parameter query?

1139

What are different types of triggers?

1176

What is a common use of group by in sql?

1094

What is serial sql?

1038

What are the two types of periodical indexes?

987

what are the different index configurations a table can have? : Sql dba

1037

What information is needed to connect sql*plus an oracle server?

1074

How does stored procedure reduce network traffic?

1064

what are different types of collation sensitivity? : Sql dba

1114

What is a scalar value in sql?

1122

What is a sql statement?

1016