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
how to calculate expressions with sql statements? : Sql dba
What are the two characteristics of a primary key?
Can we use loop in sql?
what is schema? : Sql dba
What is server name sql?
What is nvarchar max in sql?
Can we insert in sql function?
Why is sql*loader direct path so fast?
what is data integrity? : Sql dba
What is recursive stored procedure?
Can one improve the performance of sql*loader? : aql loader
what is innodb? : Sql dba
What is identity column in sql server?
how can we destroy the cookie? : Sql dba
how to include numeric values in sql statements? : Sql dba