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 difference between anonymous block and named
block or stored procedure?

Answer Posted / amruta

Anonymous block: It does not have a name. Starts with
DECLARE or BEGIN.
Named block: Starts with Header Block.
like name of block, type of block, parameter.

Is This Answer Correct ?    26 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is use pl and sql?

1105


what is the difference between primary key and unique key? : Sql dba

1082


What is graph sql?

1039


What are the types of subqueries?

1101


How do I run a pl sql procedure in sql developer?

1020


What is parallel hint?

1411


what's the difference between a primary key and a unique key? : Sql dba

1104


Is pl sql a scripting language?

1079


What is the use of count (*) in sql?

1113


Why do we create stored procedures & functions in pl/sql and how are they different?

990


How do you write an index?

1006


what happens if null values are involved in expressions? : Sql dba

1089


What is natural join in sql?

1044


What is composite primary key in sql?

1041


How to fix oracle error ora-00942: table or view does not exist

1080