how to insert the data through views? The view is depending
upon more than two tables?
how to update materalized views?
- 3 Answers
- 7141 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
Is pl sql different from sql?
What is a data manipulation language?
How to run sql statements through the web interface?
What is the purpose of normalization?
How to get unique records from a table?
What are the advantages of sql?
Explain the rollback statement?
what is recursive stored procedure? : Sql dba
What is implicit cursor in pl sql?
Explain the uses of control file.
can sql servers linked to other servers like oracle? : Sql dba
How can get second highest salary in sql?
What is trigger explain it?
Can you join a table to itself?
What is the difference between null value, zero, and blank space?
