what is the difernece between named and anonymous pl/sql
blocks??
Answer Posted / mk
the purpose of an anonymous block is to write a one time
code e.g. you can write statements using SQL PLus editor and
accomplish database changes and do stuff which you can also
do by creating a procedure
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What are reports usually used for?
how to show all tables with 'mysql'? : Sql dba
Explain the components of sql?
what are the security recommendations while using mysql? : Sql dba
How do I turn a list into a table?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is thread join () in threading?
Explain select statements in sql?
What are data types in pl sql?
How can the performance of a trigger be improved?
What is rowtype?
Can we use distinct and group by together?
What is sp_helptext?
how to calculate expressions with sql statements? : Sql dba
what is a table in a database ? : Sql dba