(1) Is there a concept called public view and private view in Oracle?
(2) If I create a view in the package specification, what is the additional benefits or differences than declaring inside package body?
(3) If I create view independently, is it a global view? what is the difference than the view created inside package?
(3) Where is the recommended way to create view? independently or inside packaged specification or package body?