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
Describe sql comments?
What is online transaction processing (oltp)?
How do I use google cloud in sql?
What is the meaning of disabling a trigger?
Can you inner join the same table?
Is a view faster than a stored procedure?
How do I upgrade sql?
What is lexical units in pl sql?
What is pivot table in sql?
Does truncate release storage space?
what is foreign key? : Sql dba
What is mutating table error?
how to select unique records from a table? : Sql dba
What is sql and explain its components?
What are pl sql data types?
