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
write an sql query to find names of employee start with 'a'? : Sql dba
Show the two pl/sql cursor exceptions.
define sql insert statement ? : Sql dba
How do we accept inputs from user during runtime?
Where do we use pl sql?
Is join an inner join?
What are the three pl sql block types?
how do you tune the slow running queries in oracle db , explain the methodology
What is sql trigger example?
What are views in sql?
What is sharding in sql?
What is pl sql collection?
What is full form of rtm?
What does truncate mean in sql?
what is a composite key ? : Sql dba