Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / santosh kumar
View is the logical representation of subset of data from
one or more table.(This is database object but depends on
the table).
there are two types of view.....
1. simple view
2. complex view
SIMPLE VIEW
note:- 1. based on one table.
2. We can perform dml in this.
3. can not contain group function.
4. can not contain group by clause.
5. dml can not be perform when the base table have
not null(primary key, not null) constraint on
any column and that is not selected in the view.
COMPLEX VIEW
note:- 1. based on one or more table.
2. We can perform dml in this always.
3. can contain group function.
4. can contain group by clause.
| Is This Answer Correct ? | 20 Yes | 5 No |
Post New Answer View All Answers
Is oracle and sql same?
Why do we use view in sql?
how to get a list of indexes of an existing table? : Sql dba
What is the main difference between sql and pl/sql?
how can we know the number of days between two given dates using mysql? : Sql dba
What is a common use of group by in sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is the difference between distinct and unique in sql?
What is difference between hql and native sql?
Is sql pronounced sequel or sql?
how can we find the number of rows in a table using mysql? : Sql dba
What is varchar example?
What is a loop in sql?
What is a dynamic query?
What are sql data types?
