anonymous block is one which has name that starts: with DECLARE, BEGIN...

What is the difference between anonymous block and named
block or stored procedure?

Question Posted / mohd mahmood ali

Answer Posted / mohd mahmood ali

anonymous block is one which has name that starts: with
DECLARE, BEGIN...
Named Block has NAME: like PROCEDURE,FUNCTION,PACKAGES

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I run sql?

1251

Can you sum a count in sql?

1059

What is the use of triggers?

1082

What is the usage of the distinct keyword?

1270

Is sql a oracle?

1020

How do you modify a column in sql?

1047

What is user in sql?

1071

What are the basic techniques of indexing?

1109

Explain the difference between rename and alias?

1062

Can we commit in trigger?

1025

who introduced sql?

1069

Why is stored procedure faster than query?

1017

how is exception handling handled in mysql? : Sql dba

1125

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1239

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

1102