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 difference b/w pravite procedures and public
procedures?

Answer Posted / a g srikanth

Any procedure that is declared and defined ONLY in the
package body is a private procedure. This procedure is
local to the package and other procs cannot call any
private procedure.

On the other hand if the procedure is defined in the
package specification and defined in the package body it is
a public procedure, this is accessible to other procs also.

Is This Answer Correct ?    30 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is composite data type in pl sql?

1122


Which tcp/ip port does sql server run?

1016


How do you modify a table in sql?

1132


What are the advantages of indexing?

991


What is a common use of group by in sql?

1053


Can we write dml inside a function in sql server?

964


What is delete command in sql?

1125


What is constant in pl sql?

1033


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1032


Can we use pl sql in mysql?

1019


How do you modify a column in sql?

1004


Is big data nosql?

957


tell me about various levels of constraint. : Sql dba

1041


What is difference between table and view?

1069


What is blind sql injection?

1079