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

What are the situations while dbms should not be used, What are the situati... What are the situations while DBMS should not be used? DBMS should not be used in situations like: (i) No need of security. (ii) Not difficulty to access the data (iii) N

Attribute preservation, Attribute Preservation This is a easy and obvio... Attribute Preservation This is a easy and obvious necessity that includes preserving all the attributes that were there in the relation that is being decomposed.

Explain the structure of well formed formulae, Explain the structure of wel... Explain the structure of well formed formulae in relational calculus. Ans: a. An atom is a formula b. If P1 is a formula, after that so are ¬P1 and (P1) c. If P1 and P2 a

Data fragmentation in distributed database system, brief history,definition... brief history,definition,current trends and future trends if any of data fragmentation

Division operation, To do the division operation R1 ÷ R2, R2 should be a co... To do the division operation R1 ÷ R2, R2 should be a correct subset of R1. In the following example R1 have attributes A and B and R2 have only attribute B so R2 is a correct subse

Describe the composite key, Describe the Composite Key Composite Key: ... Describe the Composite Key Composite Key: Sometimes one key is not enough to uniquely recognize a row. E.g. in a single class Roll is enough to search a student, but in the w

What are the requirements of algorithm designer, What are the Requirements ... What are the Requirements of algorithm designer Algorithm designer should: i) Select proper algorithm so as to minimize implementation cost ii) Find most appropriate d

What is object containment, What is object containment? References amon... What is object containment? References among objects can be used to model dissimilar real-world concepts.

Student database, tell me the functionality,advantages and disadvantages of... tell me the functionality,advantages and disadvantages of student database

Delete - referential integrity, During the deletion of a tuple two cases ca... During the deletion of a tuple two cases can happen: Deletion of tuple in relation having the foreign key: In this type of case simply delete the desired tuple. For example, in