In view we cannot do DML commands where as it is possible in Materialized

Whatis the difference between View and Materialized View ?

Question Posted / guest

Answer Posted / guest

In view we cannot do DML commands where as it is possible
in Materialized view.

Is This Answer Correct ?

39 Yes

121 No

Please Help Members By Posting Answers For Below Questions

How to load data in informatica ?

1069

how many types of dimensions are available in informatica?

1180

What is meant by LDAP users?

1288

Parameter and variable differences

2110

What is the difference between writing a joiner query in ANSI style and THETA style?

2436

How to elaborate powercenter integration service?

1174

Please let me know how to make encryption and decryption with example?

1947

What is the difference between source qualifier transformations source filter to filter transformation?

1096

How we can create indexes after completing the load process?

1200

What is an unconnected transformation?

1130

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2125

What are the different transaction levels available in transaction control transformation?

1274

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1129

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2113

What is the use of source qualifier?

1185