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
- 8397 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 primary key in db?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Differentiate between pl/sql and sql?
How do you use a while loop in pl sql?
Can we use distinct and group by together?
How do I edit a trigger in sql developer?
Why use truncate instead of delete?
What is raid? How does it help storage of databases?
How to pipe multiline string to isql?
What is the difference between numeric and autonumber?
What are reports usually used for?
What is the maximum size of sqlite database?
What is fmtonly in sql?
what happens if null values are involved in expressions? : Sql dba
What is not null in sql?
