Declaration block Execution block Exception block

What are the blocks in stored procedure?

Question Posted / eshwer

Answer Posted / eshwer

Declaration block
Execution block
Exception block

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1027

Why commit is not used in triggers?

1024

What is compound trigger?

1016

What is Materialized View? In What Scenario we Use Materialized View?

9485

Can we join same table in sql?

1000

What is column?

975

How would you reference column values before and after you have inserted and deleted triggers?

1049

how tsql statements can be written and submitted to the database engine? : Transact sql

967

What is difference between function and trigger?

1024

What does the hierarchical profiler does?

1048

What is autocommit sql?

969

discuss about myisam index statistics collection. : Sql dba

938

Is sql pronounced sequel or sql?

1247

What is sql character function?

1052

How do I write a sql query in pgadmin 4?

962