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 is input buffer in sql*plus?
What is the order of sql select?
what are wild cards used in database for pattern matching ? : Sql dba
What is primary key secondary key alternate key candidate key?
Does db2 use sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is sql resultset?
What is exception? What are the types of exceptions?
Why commit is not used in triggers?
What is procedure explain with program?
What is null in pl/sql?
Can a table have no primary key?
How to read xml file in oracle pl sql?
what are the differences between require and include, include_once and require_once? : Sql dba
what is bcp? When is it used?