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?

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

Can a primary key be a foreign key?

0 Answers  


Why schema is used in sql?

0 Answers  


What is a left join?

0 Answers  


TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,


what is meant by nl2br()? : Sql dba

0 Answers  


How do you exit in sql?

0 Answers  


How to get list of all tables from a database?

0 Answers  


What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,


What is dml with example?

0 Answers  


Differentiate between pl/sql and sql?

0 Answers  


what is a cursor

9 Answers   IBM, TCS, Wipro,


Why is normalization important?

0 Answers  


Categories