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
Is join an inner join?
Is sql between inclusive?
What is %rowtype in pl sql?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is the command used to fetch first 5 characters of the string?
Can we use distinct and group by together?
How do I truncate a sql log file?
how to select unique records from a table? : Sql dba
how to increment dates by 1 in mysql? : Sql dba
What is the difference between cross join and natural join?
What is thread join () in threading?
What are the types of variables use in pl sql?
How subquery works in sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
what is query cache in mysql? : Sql dba