If the view is complex this can take sometime, this is where a materialized views comes in, unlike a view it contains space and storage just like a regular table.
You can even partition them and create indexes on them.
A view does not exist, basically its a definition defined within the data dictionary, lots of the DBA_ are views.
update outemp set dname = 'dkjsk' where ename = 'C Farmer'; update outemp set dname = 'dkjsk' where ename = 'C Farmer' * ERROR at line 1: ORA-01407: cannot update ("SCOTT"."EMP"."DEPTNO") to NULL ORA-06512: at "SCOTT.
The fields in a view are fields from one or more real tables in the database.
You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
In SQL, a view is a virtual table based on the result-set of an SQL statement.
A view contains rows and columns, just like a real table.