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 are the built in functions of sql?

1030


Can we insert data in view?

963


What does sign mean sql?

1111


what is column? : Sql dba

1002


How do you update a value in sql?

1043


What is AUTH_ID and AUTH_USER in pl/sql ?

2193


how to run 'mysql' commands from a batch file? : Sql dba

1120


How many sectors are in a partition?

1076


Can we use view in stored procedure?

900


What is hibernate and its relation to sql?

1123


what happens if you no create privilege in a database? : Sql dba

1001


How do I view an execution plan in sql?

983


What is nosql db?

970


What is the left table in sql?

963


How do I edit a trigger in sql developer?

993