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
- 58471 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
Is left join same as join?
How do I save a stored procedure?
How do you declare a constant?
What is sql not null constraint?
how to use myisamchk to check or repair myisam tables? : Sql dba
What is the function that is used to transfer a pl/sql table log to a database table?
How many sql commands are there?
How to display the current date in sql?
What is rownum and rowid?
How do you determine the current isolation level? : Transact sql
How many types of tables are there?
What are all types of user defined functions?
How to place comments in pl/sql?
What are the different types of joins in sql?
Write an sql query to select all records from the table?
