what is the difernece between named and anonymous pl/sql
blocks??
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
Differentiate between syntax and runtime errors.
Write the command to remove all players named sachin from the players table.
What is sp_helptext?
What is native sql query?
When sql appeared?
what is view? : Sql dba
what is a control file ? : Sql dba
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How to set up sql*plus output format in oracle?
How can I delete duplicate rows?
What is a composite primary key?
What is the difference between sql and mysql?
What is the difference between a procedure and a function?
what is log shipping? : Sql dba
What is the difference between unique and primary key constraints?