Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 21959 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 is a constraint? Tell me about its various levels. : Sql dba
What are the different type of joins in sql?
What is the limitation on the block size of pl/sql?
Why do we use sqlite?
Difference between table function and pipelined function?
How bulk collect improves performance?
What is primary key and unique key?
What are the events on which a database trigger can be based?
Is pl sql a scripting language?
What are joins in sql?
What is server name sql?
How do you change a value in sql?
Is it possible to read/write files to-and-from PL/SQL?
What is the execution plan in sql?
What is union and union all keyword in sql?
