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
What is partition in sql query?
What is a full join sql?
how to load data files into tables with 'mysqlimport'? : Sql dba
what are numeric data types? : Sql dba
Mention what problem one might face while writing log information to a data-base table in pl/sql?
Is join and inner join the same?
How many commands are in sql?
what is transaction? : Sql dba
How to create a menu in sqlplus or pl/sql?
What is a natural join?
Does truncate free space?
Can we alter stored procedure?
Mention what does the hierarchical profiler does?
Explain the rollback statement?
Can a trigger call a stored procedure?