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
How do I edit a stored procedure?
How do sql databases work?
What is java sql package?
What is the difference between delete and truncate commands?
What is a database trigger?
What is rtm stands for?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is consistency?
how to create a new view in mysql? : Sql dba
Can sql function call stored procedure?
How do I know if I have sql express or standard?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
how can you see all indexes defined for a table? : Sql dba
How to start oracle sql developer?