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

Why use stored procedures?

1016

What is dcl in sql?

903

Determine if oracle date is on a weekend?

980

What is trigger in sql?

1026

What is primary key in db?

933

How do you change a value in sql?

964

Can a primary key be a foreign key?

968

Difference between table function and pipelined function?

966

What are the indexing methods?

1001

How do I view tables in sql developer?

881

What is rename in sql?

915

What is left join in sql?

1003

What is scalar function?

998

What is the purpose of the primary key?

1004

What is sql profiling in oracle?

992