how to insert the data through views? The view is depending
upon more than two tables?
how to update materalized views?
- 3 Answers
- 7786 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
Why we use pl sql?
Can triggers stop a dml statement from executing on a table?
Is it possible to link two groups inside a cross products after the cross products group has been created?
How do you know if a relationship is 2nf?
Are null values same as that of zero or a blank space?
What is pl sql variable?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What does count (*) do in sql?
How do I find duplicates in sql?
Do we need to create index on primary key?
How does postgresql compare to oracle/db2/ms sql server/informix?
Why do we create views in sql?
Can a trigger call a stored procedure?
What is on delete restrict?
Is delete faster than truncate?
