what is difference b/w pravite procedures and public
procedures?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How to run sql*plus commands in sql developer?
What is the use of non clustered index?
How to execute a stored procedure?
what is purge command explain about oracle performance tuning
2 Answers Accenture, eCentric Solutions,
what is sql profiler? : Sql dba
What are the different types of functions in sql?
how to create a database in oracle?
Which table is left in left join?
What are the two virtual tables available at the time of database trigger execution?
What is the syntax and use of the coalesce function?
How you improve the performance of sql*loader? : aql loader
if a string is there like s1,s2,s3,s4.How to find count of commas in this.