Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between anonymous block and named
block or stored procedure?
- 8 Answers
- 59162 Views
- I also Faced
- E-Mail Answers
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
What is query execution plan in sql?
what is denormalization. : Sql dba
What is rownum?
What is synonyms?
how is myisam table stored? : Sql dba
How to write html code in pl sql?
What does seeding a database mean?
What are its different types of dbms?
What is the difference between alter trigger and drop trigger statements?
how to concatenate two character strings? : Sql dba
How does pl sql work?
When do we use triggers?
Can 2 queries be executed simultaneously in a distributed database system?
What is sqlcommand?
how to get a list of indexes of an existing table? : Sql dba
