what is difference b/w pravite procedures and public
procedures?
- 3 Answers
- 19212 Views
- Steria, Wipro, Zensar, I also Faced
- E-Mail Answers
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
What is a sql instance vs database?
What is a left inner join?
What is the difference between null value, zero, and blank space?
what are all different types of collation sensitivity? : Sql dba
Does oracle use sql?
How to make a copy values from one column to another in sql?
Which nosql database is best?
What is view? Can we update view
What is dml and ddl?
Explain the types of joins in sql?
Which constraints we can use while creating database in sql?
What is pl sql in dbms?
What is the use of procedures?
Why do we need pl sql?
How to return an array from java to pl/sql?
