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 the use of <> sql?
What is sql and also describe types of sql statements?
how to rename an existing table in mysql? : Sql dba
Explain the difference in execution of triggers and stored procedures?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
How can we make an if statement within a select statement?
What does truncate mean in sql?
How do you respond to dementia behavior?
what is oltp (online transaction processing)? : Sql dba
Is clustered index a primary key?
What is the difference between python and sql?
Can you load data into multiple tables at once? : aql loader
What is native sql query?
What is sqlexception in java?
Which join is default?