Can you have a view within a view?

Question

No, it's fine. In many cases I personally consider it preferable to writing one view with a giant and difficult to understand definition. In my opinion, using multiple views allows you to: Encapsulate discrete logic in individual views. 10 окт. 2012 г.

Can a view refer to another view?

Yes a view can be based on another view. For example data dictionary views can be used to create another view in order to improve better access.

Can we CREATE VIEW on view in Oracle?

The syntax for the CREATE VIEW Statement in Oracle/PLSQL is: CREATE VIEW view_name AS SELECT columns FROM tables [WHERE conditions]; view_name. The name of the Oracle VIEW that you wish to create.

Can you create a view on view in Snowflake?

When you create a view and then grant privileges on that view to a role, the role can use the view even if the role does not have privileges on the underlying table(s) that the view accesses. This means that you can create a view to give a role access to only a subset of a table.

Can a view be used as a data source for other views?

In another parallel with functions, database users can manipulate nested views, thus one view can aggregate data from other views. Without the use of views, the normalization of databases above second normal form would become much more difficult. Views can make it easier to create lossless join decomposition.

Expert · Answer