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

what are the join types in tsql? : Transact sql

1064

How do I know if I have sql express or standard?

1032

explain the difference between myisam static and myisam dynamic. : Sql dba

944

What is interval partition?

1053

What is the difference between clustered and non-clustered indexes?

1089

how to drop an existing index in mysql? : Sql dba

1069

what is the difference between sql and t-sql? : Transact sql

1084

What are the features of pl sql?

1067

Why use truncate instead of delete?

1015

What is cursor in pl sql with examples?

1033

What is the advantage of nosql?

1061

Does truncate free space?

1007

Can we use the cursor's to create the collection in PL/SQL?

1025

In a distributed database system, can we execute two queries simultaneously?

1090

Can we use view in stored procedure?

900