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 left join same as inner join?
Which join is like inner join?
What is sql clause?
explain mysql aggregate functions. : Sql dba
How is pl sql different from sql?
What is rowid in sql?
What is the maximum rows in csv?
What is oracle and pl sql?
what is a constraint? Tell me about its various levels. : Sql dba
Can a procedure in a package be overloaded?
How do you modify a trigger?
What programs use sql?
Write a query to find the names of users that begin with "um" in sql?
What is auto increment in sql?
What is the maximum size of sqlite database?