Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difernece between named and anonymous pl/sql
blocks??
- 8 Answers
- 21301 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
explain access control lists. : Sql dba
what is a composite primary key ? : Sql dba
How will you distinguish a global variable with a local variable in pl/sql?
what are the t string functions available in tsql? : Transact sql
Why are indexes and views important to an organization?
Does sql full backup truncate logs?
Differentiate between syntax and runtime errors.
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Is natural join and inner join same?
Can we use having without group by in sql?
What is sqlca in powerbuilder?
What is the difference between local variables and global variables?
What is auto increment?
What is a full join?
What is cursor status?
