what is difference b/w pravite procedures and public
procedures?
Answer Posted / 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 |
Post New Answer View All Answers
explain mysql aggregate functions. : Sql dba
What is a database? Explain
What are the different types of triggers?
How can we optimize a sql query?
What is scope and visibility in PL/SQL?
What is the difference between partitioning and sharding?
How many types of index are there?
Explain the difference between triggers and constraints?
What is not null in sql?
What is cold data?
What is numeric function sql?
Which normal form is best?
How do I view a procedure in sql?
What trigger means?
Can we insert in sql function?