Skip to Main Content

Portuguese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where to create view

2992177Jul 18 2016 — edited Jul 18 2016

(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?

Comments
Post Details
Added on Jul 18 2016
0 comments
546 views