Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is input buffer in sql*plus?

1208


What is the order of sql select?

1040


what are wild cards used in database for pattern matching ? : Sql dba

1135


What is primary key secondary key alternate key candidate key?

1029


Does db2 use sql?

937


explain the options of myisamchk to improve the performance of a table. : Sql dba

1003


What is sql resultset?

979


What is exception? What are the types of exceptions?

1066


Why commit is not used in triggers?

1034


What is procedure explain with program?

1011


What is null in pl/sql?

1061


Can a table have no primary key?

1051


How to read xml file in oracle pl sql?

909


what are the differences between require and include, include_once and require_once? : Sql dba

1018


what is bcp? When is it used?

1101