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 / vaibhavi_dixit

Anonymous block those pl/sql blocks which are not stored in
your DB as an objects, whereas named pl/sql blocks are
those blocks which are stored in DB as an objects.Due to
storage in DB, these named pl/sql blocks can be called from
another named or anonymous blocks, or from any form also...

Is This Answer Correct ?    34 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a sql instance vs database?

1174


What is dcl in sql?

1024


What is the purpose of a secondary key?

1018


What type of database is cloud sql?

1158


Explain constraints in sql?

1088


What is scalar function in sql?

1100


What are the popular database management systems in the it industry?

1037


What is join view in sql?

989


What is sqlerrm?

986


What is the difference between Union and Union all. Which is faster.

1441


what is the difference between where clause and having clause? : Sql dba

1045


What are crud methods?

1086


How to test for null values?

1098


what is the syntax used for partition in tsql? : Transact sql

1060


What is trigger explain with example?

1092