Can we CREATE VIEW from view in Oracle?

Question

Use the CREATE VIEW statement to define a view, which is a logical table based on one or more tables or views. A view contains no data itself. The tables upon .

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 VIEW from view?

You can certainly have a view that's built on top of another view: create table my_table (id number, name varchar2(20), address varchar2(30)); table MY_TABLE created. create or replace view my_view_1 as select id, name from my_table; view MY_VIEW_1 created.

Can a view based on 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 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.

Expert · Answer