Forum Stats

  • 3,769,960 Users
  • 2,253,036 Discussions
  • 7,875,253 Comments

Discussions

Where to create view

2992177
2992177 Member Posts: 39
edited Jul 18, 2016 5:45AM in SQL and PL/SQL (Portuguese)

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