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
Explain architecture of sql server notification services?
What is t sql used for?
Explain the update statement in sql
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
How to make a copy values from one column to another in sql?
What is sqlerrm?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Can we debug stored procedure?
what are the t string functions available in tsql? : Transact sql
What is sorting in sql?
Is subquery faster than join?
What is the current version of postgresql?
How to create a menu in sqlplus or pl/sql?
How many types of cursors supported in pl/sql?
What does where 1/2 mean in sql?