what is the difernece between named and anonymous pl/sql
blocks??
Answer Posted / purushotham
Named pl/sql blocks are nothing but procedures.
procedures are compiled and stored in the database and
a user can call the procedure when required.
whereas anonymous are unnamed pl/sql blocks that will be
available for the time that is executed and it will not the
stored in the Database.
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Why plvtab is considered as the easiest way to access the pl/sql table?
Can you upgrade sql express to full sql?
How to start oracle sql developer?
What are sql indexes?
What is union and union all keyword in sql and what are their differences?
How do you exit in sql?
what is a view? : Sql dba
What is having clause in sql?
What is exception? What are the types of exceptions?
which tcp/ip port does sql server run on? : Sql dba
What is a unique constraint?
Explain spool.
What does count (*) mean in sql?
Can dml statements be used in pl/sql?
What is numeric function sql?