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

anonymous is unnamed plsql block, cannot save in database,
cannot allow any mode of parameter.

stored programs are saved into database and we can recall
them whenever programe require it, it accept the mode of
parameter like
in,in out,out.

Is This Answer Correct ?    55 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to combine two stored procedures in sql?

1232


Is sql free?

957


Explain the difference between 'between' & 'and' operators in sql

997


What is the maximum size of sqlite database?

1106


what is the difference between truncate and delete statement? : Transact sql

1060


Can we insert delete data in view?

950


Explain what is an index?

1054


Is inner join faster than left join?

1190


What is the difference between drop and truncate commands?

1060


Why use stored procedures?

1087


What are all the ddl commands?

1180


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1164


how many values can the set function of mysql take? : Sql dba

985


Are stored procedures faster than queries?

943


Why use triggers in sql?

956