What is the difference between anonymous block and named
block or stored procedure?
Answer Posted / ranjith
The anonymous block statement is an executable statement
that can contain PL/SQL control statements and SQL
statements. It can be used to implement procedural logic in
a scripting language.
named block or stored procedure is a pl/sql block that
oracle stores in the database and can be called by name
from any application
examples are function,procedure and packages,etc.....
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Write a query to find the names of users that begin with "um" in sql?
what is isam? : Sql dba
What is right join sql?
What is normalization in sql?
Is not equal in sql?
Can you load data into multiple tables at once? : aql loader
what is timestamp in mysql? : Sql dba
What is the difference between mdf and ndf files?
How can I tell if sql is running?
What is raw datatype in sql?
How many joins can you have in sql?
Why is a trigger used?
What is the main reason behind using an index?
what is transaction? : Sql dba
what is self-join? : Sql dba