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
What is primary and foreign key?
How to sort the rows in sql.
What are all ddl commands?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What are two statement types in sql?
Does execute immediate commit?
List different type of expressions with the example.
How many postgresql users are there, worldwide?
how to dump a table to a file with 'mysqldump'? : Sql dba
what is column? : Sql dba
What is information schema in sql?
What are the uses of sysdate and user keywords?
Is sql developer case sensitive?
What does where 1/2 mean in sql?
What is a nested table in word?