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


Please Help Members By Posting Answers For Below Questions

How do you pronounce sql?

551


How to pronounce postgresql?

582


What is the difference between database trigger and stored procedure?

557


How to change sql*plus system settings?

544


Why we use sql profiler?

562






Name some usages of database trigger?

564


What does t sql mean?

536


How many databases can sql express handle?

536


What does the sign mean in sql?

507


How long it takes to learn pl sql?

533


What is consistency?

715


How do I pipe the output of one isql to another?

532


What is posting?

609


How does pl sql work?

528


How is data stored on a disk?

541