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
Can we insert in view in sql?
What is Difference Between Unique and Primary Key Constraints?
Show code of a cursor for loop.
What are the uses of sysdate and user keywords?
What are inner and outer joins examples of both?
what are string data types? : Sql dba
Does view contain data?
how to convert dates to character strings? : Sql dba
What are the qualities of 2nf?
How many types of triggers are there in pl sql?
What is oracle sql developer?
How sql query is executed?
Why we use joins in sql?
How to set up sql*plus output format in oracle?
What is the usage of the distinct keyword?
