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

explain mysql aggregate functions. : Sql dba

986


What is a database? Explain

1108


What are the different types of triggers?

1136


How can we optimize a sql query?

1049


What is scope and visibility in PL/SQL?

1204


What is the difference between partitioning and sharding?

1008


How many types of index are there?

1040


Explain the difference between triggers and constraints?

975


What is not null in sql?

1055


What is cold data?

959


What is numeric function sql?

1059


Which normal form is best?

948


How do I view a procedure in sql?

969


What trigger means?

977


Can we insert in sql function?

1081