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 use sql*plus built-in timers?

1200


what is not null constraint? : Sql dba

1029


what are date and time functions in mysql? : Sql dba

979


What is materialized view. What are different methods of refresh?

1393


Is sql pronounced sequel or sql?

1262


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3050


Why we use stored procedure instead of query?

998


What are the operators in sql?

1028


Which is better cte or subquery?

1028


What is pivot table in sql?

1107


What are the key differences between SQL and PL SQL?

1212


Is not equal in sql?

1013


who introduced sql?

1019


What is latest version of sql?

1044


Can we group by two columns in sql?

996