when adding view to screen specify the type as aggregate view.But Before that you should create the parent category.then add this parent category to aggrega...
Normal Views are for Access purpose ie One need to give access the end user to specific data.
Materialized Views are to optimize the performance . WHen mater...
View - store the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes.
Materialized view -...
If we have several tables in a db and we want to view only specific columns from specific tables we can go for views. It would also suffice the needs of securit...
A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view...
No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same...
View - A view is a virtual table containing fields from one or more tables. A virtual table that does not contain any data, but instead provides an application-...
A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying bas...