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
- 8609 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 a null value?
What are the operators used in select statements?
How to select random rows from a table?
What is a design view?
What is the best partition size for windows 10?
How do I run sql profiler?
how to get @@error and @@rowcount at the same time? : Sql dba
what are properties of a transaction? : Sql dba
How do I start sql from command line?
What are conditional predicates?
What are sql built in functions?
Can a composite key be null?
Can we join same table in sql?
What are the different types of triggers?
What are basic techniques of indexing?
