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

Can we join two tables without common column?

0 Answers  

What does (+) mean in sql joins?

0 Answers  

What is Histogram?

0 Answers   NIIT,

How many types of sql are there?

0 Answers  

how to fetch common records from two tables? : Sql dba

0 Answers  




Explain correlated query work?

0 Answers  

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

Which are the different case manipulation functions in sql?

0 Answers  

What is an ndf file?

0 Answers  

How to rename a column in the output of sql query?

0 Answers  

What are the basic techniques of indexing?

0 Answers  

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories