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

Is join an inner join?

898


Is sql between inclusive?

1064


What is %rowtype in pl sql?

925


The in operator may be used if you know the exact value you want to return for at least one of the columns.

1029


What is the command used to fetch first 5 characters of the string?

1336


Can we use distinct and group by together?

994


How do I truncate a sql log file?

1008


how to select unique records from a table? : Sql dba

1058


how to increment dates by 1 in mysql? : Sql dba

928


What is the difference between cross join and natural join?

963


What is thread join () in threading?

948


What are the types of variables use in pl sql?

972


How subquery works in sql?

997


What is out parameter used for eventhough return statement can also be used in pl/sql?

1016


what is query cache in mysql? : Sql dba

993