Type of views-data control, Database Management System

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







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
Related Questions
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? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

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? Nested relations The assumption of INF is a natural one in the bank examples we have considered. However, not all applications are best modelled

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

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

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 automobile sales company

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 when you are going to use inheritance as an implementation technique, you can achieve same goal in a safer way by making one cla