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
- 8757 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 rollback?
What do you understand by pl/sql cursors?
What is execution plan in sql?
What is error ora-01000: maximum open cursors exceeded
What is the maximum size of sqlite database?
What are the advantages of pl sql?
What are different types of sql?
What is sqlservr exe?
What is trigger with example?
Which command is used to delete a trigger?
What does truncate mean in sql?
Enlist some predefined exceptions?
What are string functions in sql?
What is an oracle stored procedure?
What are the different types of joins in sql?
