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
The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced

Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering

WRITE SHORT NOTES ON INDEX STRUCTURE OF FILES? There are two basic parts of indices 1.   Ordered indices 2.   Hash indices Every technique must be evaluated on the bas


An entity type usually has an attribute whose values are distinct for every individual entity in the collection. Such an attribute is known as a key attribute and its values can be

Rearrange the Execution Order for Efficiency  Rearranging execution order for efficiency means executing such job that requires less execution time. By rearranging the object

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

What is the use of sub queries? A sub query is a select-from-where expression that is nested with in another query. A common use of sub queries is to do tests for set membershi

design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.

Define Direct file organization? The direct file organization is employed to enhance the performance in accessing the records than sequential file organization. In direct file