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
- 58885 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
Why do we use partitions in sql?
What are sql triggers used for?
what is 'mysqladmin' in mysql? : Sql dba
What is clause in sql?
how to install mysql? : Sql dba
What are tables and fields?
How do you copy a table in sql?
Explain how exception handling is done in advance pl/sql?
What is clause?
Can we use join in subquery?
How do you select unique values in sql?
List the different type of joins?
What is ttitle and btitle?
how to get help information from the server? : Sql dba
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
