Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 21641 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
Why stored procedure is faster than query?
What is clustered and nonclustered index in sql?
how to use regular expression in pattern match conditions? : Sql dba
Which nosql database is best?
Does truncate remove indexes?
What is a pragma statement?
what are string data types? : Sql dba
Explain the types of joins in sql?
What are the disadvantages of file system?
What is union?
How can I change database name in sql?
Why is pl sql used?
what is schema? : Sql dba
how to include numeric values in sql statements? : Sql dba
What is primary key sql?
