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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is primary and foreign key?

571


How to sort the rows in sql.

577


What are all ddl commands?

523


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

504


What are two statement types in sql?

512






Does execute immediate commit?

666


List different type of expressions with the example.

532


How many postgresql users are there, worldwide?

541


how to dump a table to a file with 'mysqldump'? : Sql dba

533


what is column? : Sql dba

553


What is information schema in sql?

550


What are the uses of sysdate and user keywords?

595


Is sql developer case sensitive?

491


What does where 1/2 mean in sql?

510


What is a nested table in word?

514