Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 21289 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 the file extension for sql database?
Is t sql a programming language?
discuss about myisam key cache. : Sql dba
How many types of cursors supported in pl/sql?
Show the two pl/sql cursor exceptions.
How to get each name only once from an employee table?
What is offset in sql query?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Which certification is best for sql?
Why are aggregate functions called so?
What is the difference between function and procedure in pl/sql?
Define implicit and explicit cursors.
What is primary and foreign key?
Is join and inner join the same?
What are different types of indexes?
