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 text? : Sql dba

1073

what is 'mysqlimport'? : Sql dba

1054

What is the syntax and use of the coalesce function?

1175

What is server name sql?

1148

What is cursor in pl sql with examples?

1034

what is a composite primary key ? : Sql dba

1053

how to create a table index in mysql? : Sql dba

1061

Define the select into statement.

1059

What is sql data?

996

What will you get by the cursor attribute sql%notfound?

1075

How much does a sql dba make? : SQL DBA

948

Is sql procedural language?

968

Is big data nosql?

949

What is character functions?

1061

How do you run a query?

990