What is the difference between anonymous block and named
block or stored procedure?
Answer Posted / kavitha
An anonymous block is a pl/sql block that appears in your
application and is not named and stored in your database.
A stored procedure or a named block is a pl/sql block that
oracle stores in the database and can be called by name
from any application
Is This Answer Correct ? | 41 Yes | 12 No |
Post New Answer View All Answers
Is sql a backend?
What is substitution variable in pl sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is substitution variable?
When is the update_statistics command used?
Which type of cursor is used to execute the dml statement?
What is latest version of sql?
How does sql*loader handles newline characters in a record? : aql loader
What is mdb stand for?
What does truncate mean in sql?
Which command is used to call a stored procedure?
What is nosql vs sql?
What is the difference between view and stored procedure?
Why is sql better than hql?
How is a process of pl/sql compiled?