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

Which file organization provides very fast access, Which file organization ... Which file organization provides very fast access to any arbitrary record of a file? Hashed file organization provides very fast access to any arbitrary record of a file.

What is an index, What is an index? An index is a structure that helps ... What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

Sql query for testing triggers and stored procedures , Demonstrate your kno... Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Explain nested relations, Explain nested relations? Nested relations ... Explain nested relations? Nested relations The assumption of INF is a natural one in the bank examples we have considered. However, not all applications are best modelled

File organization, what is file organization? what are file organization te... what is file organization? what are file organization techniques.explain in detail? explain random file organization technique, multikey file organization technique?what is indexin

Calculate the joint probability, Consider the following frequency counts o... Consider the following frequency counts of some itemsets in a transaction database r : freq({A}, r) = 0.405 freq({B}, r) = 0.510 freq({C}, r) = 0.303 freq({A

Concurrent transactions-backup and recovery, Representing complex relations... Representing complex relationship among data A database may contain varieties of data interrelated to each other in numerous ways. A DBMS must have the capability to represent

Design a gennalization and specialization hierarchy for an a, Design a genn... Design a gennalization and specialization hierarchy for an automobile sales company

Determine the object-oriented design process, An object-oriented design pro... An object-oriented design process  1. Define the context and modes 2. Designs the system architecture 3. Identifies the principal system objects 4. Identifies concurrency in

Use inheritance as an implementation technique, Use inheritance as an imple... Use inheritance as an implementation technique when you are going to use inheritance as an implementation technique, you can achieve same goal in a safer way by making one cla