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 do you mean by rowid?

1021


What is cold data?

1006


Is it possible to create the following trigger: before or after update trigger for each row?

1347


How many types of literals are available in pl sql?

1164


Why coalesce is used in sql?

1059


how to write date and time literals? : Sql dba

1006


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1123


Does google use sql?

1002


What does fetching a cursor do?

1129


What is type and rowtype in pl sql?

1054


How to Declare Fixed Length String Value In PL SQL

1201


what is rollback? : Sql dba

1176


How do you declare a user-defined exception?

1070


Is natural join same as inner join?

981


How do you truncate?

949