how to insert the data through views? The view is depending
upon more than two tables?
how to update materalized views?
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
How do sql triggers work?
What is memory optimized table?
How many scalar data types are supported in pl/sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What are the constraints available in sql?
What is sql performance tuning?
Why stored procedure is faster than query?
What is spool?
What are inner outer left and right joins in sql?
what is an alias command? : Sql dba
What is trigger types of trigger?
Define a temp table?
What are pl/sql packages?
what is an extent ? : Sql dba
What is a heap in sql?