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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is difference b/w pravite procedures and public
procedures?

Question Posted / rameshrevella

Answers were Sorted based on User's Feedback



what is difference b/w pravite procedures and public procedures?..

Answer / 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

what is difference b/w pravite procedures and public procedures?..

Answer / siva

If the procedure is with in the package it is the public
procedure,other wise it is private procedure.

Is This Answer Correct ?    18 Yes 8 No

what is difference b/w pravite procedures and public procedures?..

Answer / swati sucharita

private procedure is used before class name.if we have
declared private before class name then subclass cannot
inherit the properties of private class.
public procedure is used before class name,if we have
declared public before class name then all other class can
inherit the properties of public class.

Is This Answer Correct ?    3 Yes 5 No

Post New Answer

More SQL PLSQL Interview Questions

How many functions are there in sql?

0 Answers  

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,

Does mysql_real_escape_string prevent sql injection?

0 Answers  

What is difference between group by and partition by?

0 Answers  

What is dml and ddl?

0 Answers  

What is integrity in sql?

0 Answers  

How do I view tables in sql developer?

0 Answers  

How pl/sql source code can be protected?

3 Answers  

How to set up sql*plus output format in oracle?

0 Answers  

Why do we use triggers?

0 Answers  

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories