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
What is composite data type in pl sql?
Which tcp/ip port does sql server run?
How do you modify a table in sql?
What are the advantages of indexing?
What is a common use of group by in sql?
Can we write dml inside a function in sql server?
What is delete command in sql?
What is constant in pl sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
Can we use pl sql in mysql?
How do you modify a column in sql?
Is big data nosql?
tell me about various levels of constraint. : Sql dba
What is difference between table and view?
What is blind sql injection?