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
Can a procedure in a package be overloaded?
Are null values same as that of zero or a blank space?
What is a delimiter in sas?
What is a variable in sql?
How many clustered indexes can you have?
What is #table in sql?
What is the use of prepared statement?
What are variables in pl sql?
What are the different datatypes available in PL/SQL?
What are operators available in sql?
Explain the significance of the & and && operators in pl sql.
What is recursive join in sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is an emotional trigger?
What is snowflake sql?