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

What is inner join in sql?

1000

What is using in sql?

1015

What is duration in sql profiler trace?

1020

Which data type is a composite type?

931

What is embedded sql what are its advantages?

958

What is recursive stored procedure?

1045

How can you load multi line records? : aql loader

1019

What is program debugging?

1128

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

919

What are tables in sql?

996

Can a commit statement be executed as part of a trigger?

995

What is database white box testing and black box testing?

1045

Are stored procedures faster than queries?

897

What is difference between db2 and sql?

937

How can you fetch common records from two tables?

1000