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 group by in sql?

1027


What is an inner join sql?

956


How do I view a procedure in sql?

913


what is the difference between undefined value and null value? : Sql dba

1041


What is a database trigger?

1019


Why do we create views in sql?

1055


When is a declare statement required?

1083


explain the difference between bool, tinyint and bit. : Sql dba

939


How to take user input in pl sql?

1107


What is case function?

989


what is cross join? : Sql dba

941


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

960


What's the difference between inner join and left join?

949


What is serial sql?

918


what is the difference between $message and $$message? : Sql dba

946