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

explain commit and rollback in mysql : sql dba

1004


What is a data definition language?

1094


Is crud a cuss word?

1027


What is sql scripting?

1103


Is pl sql a scripting language?

1021


What is auto increment in sql?

1112


What is sql performance tuning?

911


When should I use nosql database?

1000


What is %s in sql?

1005


What is meant by user defined function?

1037


Could you please provide oca (oracle 10g) dumps for my certification ?

5146


What are the types of variables use in pl sql?

1033


Can one improve the performance of sql*loader? : aql loader

1040


Can we delete column in sql?

1086


What do you understand by pl/sql cursors?

1080