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
What is sql partition function?
How can we solve sql error: ora-00904: invalid identifier?
Can we join two tables without common column?
What is the largest value that can be stored in a byte data field?
What is synonyms?
How do you clear the screen in sql?
Is left join inner or outer?
What is update query?
Difference between truncate, delete and drop commands?
How do you identify a primary key?
Which join is like inner join?
What are the limitations of sql express?
Why do we need pl sql?
Why is the cursor important?
explain the difference between bool, tinyint and bit. : Sql dba
