Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 21958 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
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
what is foreign key? : Sql dba
What is the difference between Union and Union all. Which is faster.
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How do you respond to dementia behavior?
Why do we need cursors in pl sql?
Explain ddl statements in pl/sql?
What is data control language?
What are all the common sql functions?
How do I create a sql database?
What does rownum mean in sql?
How to read/write files from pl/sql?
what is clause? : Sql dba
what is a relationship and what are they? : Sql dba
What is the difference between inner join and outer join?
Can you selectively load only those records that you need? : aql loader
