Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference b/w pravite procedures and public
procedures?
- 3 Answers
- 20385 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
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Why is there a need for sqlcode and sqlerrm variables?
What is oracle pl sql developer?
How do you define a foreign key?
What is the difference between truncate and drop statements?
What is the sql query to display the current date?
Is sql workbench free?
Can we call a function containing dml statements in a select query?
Can you do multiple joins in sql?
What is a primary key sql?
Explain raise_application_error.
what are the differences between require and include, include_once and require_once? : Sql dba
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Can we create index on primary key?
What is sql resultset?
