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

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

What is pl sql package?

0 Answers  

How to use transactions efficiently : transact sql

0 Answers  

What are two statement types in sql?

0 Answers  

which tcp/ip port does sql server run on? : Sql dba

0 Answers  

What do you know by pl/sql cursors?

0 Answers  

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

how to dump a table to a file with 'mysqldump'? : Sql dba

0 Answers  

Explain unique key in sql.

0 Answers  

sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)

1 Answers   Fidelity, Oracle,

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

7 Answers   PreVator,

List the various privileges that a user can grant to another user?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories