what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 19151 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 primary key sql?
Define concurrency control. : Transact sql
what is sp_pkeys? : Transact sql
i have some prob lem to tell me about my self in interview first round ...
how to increment dates by 1 in mysql? : Sql dba
Explain aggregate functions are available there in sql?
What is trigger price?
How many types of sql are there?
What is nosql example?
What is the difference between cross join and natural join?
Is the primary key an index?
What is use of package in pl sql?
Is left join inner or outer by default?
What is a common use of group by in sql?
What is consistency?
