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

what is innodb? : Sql dba

1034


Explain the the update statement in sql?

990


What do you understand by case manipulation functions?

954


what are the different functions in sorting an array? : Sql dba

969


How do you determine the current isolation level? : Transact sql

1075


What does inner join mean?

1064


How do I sort a table in sql?

983


What is asqueryable?

905


What is the file extension for sql database?

939


How to select unique records from a table?

1002


define join and explain different type of joins? : Sql dba

900


what is union, minus and interact commands? : Sql dba

1123


What is a database? Explain

1053


How can one get sql*loader to commit only at the end of the load file? : aql loader

1005


What is trigger in sql and its types?

992