what is difference b/w pravite procedures and public
procedures?
- 3 Answers
- 18471 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
Why truncate is used in sql?
What is the difference between left outer join and left join?
Do prepared statements prevent sql injection?
What is sql lookup?
What is pivot in sql?
Why triggers are used?
What is file based approach?
What is pl sql commands?
What does sql stand for?
What do you mean by stored procedures?
What does a pl/sql package consist of?
How to return multiple rows from the stored procedure?
Which is better cte or subquery?
how many groups of data types? : Sql dba
What is the best free sql database?
