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
What is the difference between unique and primary key constraints?
What is an inconsistent dependency?
What is the difference between Union and Union all. Which is faster.
What is normalization in a database?
What is tuple in sql?
What is pl sql quora?
Can you have a foreign key without a primary key?
What is blind sql injection?
How to use sql*plus built-in timers?
What is sqlcontext?
What are sql ddl commands?
What are pl/sql cursors?
What is the difference between syntax error and runtime error?
What does sign mean sql?
Can we create table inside stored procedure?