Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 21693 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
How do I send sql query results to excel?
What are its different types of dbms?
Explain what is a view?
What do you think about pl/sql?
how to include numeric values in sql statements? : Sql dba
Which normal form is best?
What are all the common sql functions?
What are dml commands?
what is myisam? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
How to run pl/sql statements in sql*plus?
What are sql indexes?
What is the plv (pl/vision) package offers?
What programs use sql?
Can we insert in sql function?
