what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 19705 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
Answer Posted / debi
annonymous blocks are the blocks of code executed on the
client server where as the named block such as(stored
procedure and functions) are the block of code executed on
the database server.so once the code is executed on the
server so no need to compile it again when the user wants
to run it again.So the program execution is faster in case
of executing the named block.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are the two different parts of the pl/sql packages?
What is materialized view. What are different methods of refresh?
Differentiate between pl/sql and sql?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is the size of partition table?
What is coalesce sql?
How do you go back in sql?
Can we use two order by clause in query?
What is sqlservr exe?
What is oracle sql called?
Can you rollback after commit?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is trigger point?
how to rename an existing table in mysql? : Sql dba
State some properties of relational databases?
