view and materialized view

[#1]

Hi Experts,

1.Difference between Table and View.

2.Difference between View and materialized view.

3.Is it possible to update the data using view.

Could you please any one help me..

Thanks&Regards

Ramesh

[Former Member]

1 - A table is physical and holds data, a view just holds SQL code.

2 - A view just holds SQL code, a materialised view becomes physical when it is refreshed

3 - Update what data? Data is updated via an update statement. To change a view, you would either alter it or drop it and recreate it.