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

MS Access 2010 - Form Updates Table, Hi there, Have an issue with my Databa... Hi there, Have an issue with my Database. I have: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit Whenever I add data into the Form, it will update the table as expect

B+ tree, construct a B+ tree for the following set of key value (2,3,5,7,11... construct a B+ tree for the following set of key value (2,3,5,7,11,19,23,29,31) in ascending order where the pointers that will fit in one node is as follows:A. four B. six C. eigh

Create a database schema, Consider a database schema consisting of four rel... Consider a database schema consisting of four relations, whose schemas are: Product (maker, model, type) PC (model, speed, ram, hd, price) Laptop (model, speed, ram, hd, s

Describe disk manager and their work, Describe disk manager and their work?... Describe disk manager and their work? Disk Manager: Responsible for fetching data regulated through file Manager from disk storage within Main memory and deciding what data to

Determine the three views of data, Determine the Three Views of Data We... Determine the Three Views of Data We know that the similar thing, if viewed from dissimilar angles produces difference sights. Similarly, the database that we have formed alrea

Need database normalization and database analysis, Developer is required to... Developer is required to do a task including: - Database Normalization - Database Analysis - ERM Diagram Details can be provided and then you can change your bid accord

Recovery techniques, Recovery Techniques: After Reading the types of failur... Recovery Techniques: After Reading the types of failures and database errors, let us talk about how to recover from the failures. Recovery can be complete using/restoring the previ

What are the three data anomalies, What are the three data anomalies that a... What are the three data anomalies that are likely to occur as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why not? A

What are the overlapping elements, What are the Overlapping elements O... What are the Overlapping elements Overlapping elements can be found by scanning all the elements in front of deleted element in priority list for the sheet and comparing them

Primary and foreign key, Primary Key The primary key is the candidate k... Primary Key The primary key is the candidate key that is selected by the database designer as the principal denotes of identifying entities within an entity set. The left candi