What is the difference between anonymous block and named
block or stored procedure?
- 8 Answers
- 56485 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 offset-fetch filter in tsql? : Transact sql
What is the largest value that can be stored in a byte data field?
How do I view a table in sql?
What is the difference between mdf and ndf files?
Explain spool.
What is set serveroutput on in pl sql?
How do you concatenate in sql?
What is the difference between sql and t sql?
explain the difference between bool, tinyint and bit. : Sql dba
what are the advantages and disadvantages of cascading style sheets? : Sql dba
How do I start sql profiler?
what are the t string functions available in tsql? : Transact sql
Compare sql & pl/sql
How do I copy a table in sql?
What is trigger in flip flop?
