Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert the data through views? The view is depending
upon more than two tables?
how to update materalized views?
- 3 Answers
- 8743 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / manikanta.srinu
DML Operations also is done by the view,if view have only
one table.For multiple tables in a view,DML operation was
not support.
how to update materalized views?
If ur master table is updated, your materialized view will
automatically get refreshed if ur materialized view is
create with ON COMMIT option. Else, you
have to REFRESH evertime once ur master is
inserted/deleted/updated.
CREATE MATERIALIZED VIEW departments FOR UPDATE AS
SELECT * FROM departmentsworld;
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
what is data control language? : Sql dba
Determine if oracle date is on a weekend?
What are the most important characteristics of pl/sql?
What is data manipulation language?
how many sql dml commands are supported by 'mysql'? : Sql dba
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
how do you control the max size of a heap table? : Sql dba
How do I view a view in sql?
How do I start sql profiler?
How many sql are there?
how to shutdown mysql server? : Sql dba
What is java sql drivermanager?
What does pragma mean?
What are types of joins?
explain advantages of myisam over innodb? : Sql dba
