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

Is sql injection illegal?

591


what is data control language? : Sql dba

582


what are the difference between clustered and a non-clustered index? : Sql dba

519


explain the difference between myisam static and myisam dynamic. : Sql dba

511


Can we use view in stored procedure?

502






What is exit statement?

537


What is the use of index in sql?

550


What is trigger in pl sql with examples?

515


what are the drivers in mysql? : Sql dba

549


Can a commit statement be executed as part of a trigger?

598


What are pl/sql cursors?

557


What is the difference between clustered and non-clustered indexes?

599


Which function is used to return remainder in a division operator in sql?

580


Is sql a oracle?

519


Difference between global and parameter variables?

1450