Type of views:

 Simple views and Difficult Views

Feature	Simple Views	Complex Views
Number of tables	One	One or more
Contain Functions	No	Yes
Contain groups of data	No	Yes
Data Manipulation	IS allowed	Not always

Let us look into some of the examples. To see all the details about existing views in

Oracle:

SELECT* FROM USER_VIEWS;

 

Posted Date: 3/11/2013 1:21:33 AM | Location : United States

Ask an Expert

Related Discussions:- Type of views-data control, Assignment Help, Ask Question on Type of views-data control, Get Answer, Expert's Help, Type of views-data control Discussions

Write discussion on Type of views-data control
Your posts are moderated

Write your message here..

Related Questions

The advantages of a database management system, The advantages of a databas... The advantages of a database management system (DBMS) include :- Data integrity and elimination of duplication.

IT Assignmnet, i need help for assignment .. i need help for assignment ..

A database administrator'', A database administrator''s responsibilities an... A database administrator''s responsibilities and data contents

Describe integrity and security, Describe integrity and security? a)   ... Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

Prepare an erd for the scenario, Question: (a) Prepare an ERD for the s... Question: (a) Prepare an ERD for the scenario given below. (b) Convert the ER diagram produced in (a) above into its physical design. You have to choose an appropriate Pri

Explain the concept of deadlock, Explain the concept of deadlock Yes. I... Explain the concept of deadlock Yes. It can direct to deadlock. Suppose that a batch of frames arrived correctly and were accepted. Then receiver will advance its window. Now s

Where does view definition stored, Where does view definition stored? ... Where does view definition stored? A view definition is permanently stored as part of the database.

Database system, how the string works as keyword? how the string works as keyword?

Joins, how can apply joins on table how can apply joins on table

Data handling and research methods, Data Handling and Research Methods: ... Data Handling and Research Methods: The dataset encompassing 130 participants contains several variables measuring detrimental health related behaviours referring to the use o