Oracle Interview Question - oracle difference between view and materialized view

Hi shiva, which sceneries view and Mview will use, please make the video

what is the purpose of creating materialized view??

very helpful, explained in a very simple way, thanks for the amazing content.

Can we create index on view or Mview and can we perform DML on Mview ??

your videos are so much helping brother

Pls improve sound quality

Hi Siva,
Could you please confirm how many Mviews are there.Could you please make a video on How to create types of Materialized view 1. READ ONLY 2. WRITABLE3. UPDATABLE
Note: particularly How to create Updatable Mview and give us an example of how to update the base table through Updatable Mview.

Thanks in Advance...

Please upload this video with an example? Views are created on top of materialized views ? And How?

How to add columns in view

create or replace materialized view vw_emp as select * from employees where department_id=50; not working in sql devoloper

Hi Shiva, your way of teaching is quite interesting .have an question on this part whether we able to do any modification in created M-view without dropping.

Hi Sir , nice explanation.
I have one query, currently I'm creating one Mview (base on 2-3 table) monthly on first date but while using that Mview, in next day some of the packages (base on Mview) going in invalid objects status .
So kindly clarify why this packages going in invalid objects status and how to avoid it ?
Thanks in advance

Can we do DML om MV?

Appreciate your hard work!
Well as per my experience : If you practice this playlist you are good to clear any service based firm for PLSQL role !
can't we use CREATE OR REPLACE MATERIALIZED VIEW mv_name ; syntax ?😃

👍👍👍👍

Superb superb explanation sir thank you for such great information 🙏

Ji enable query write ku , seperate video poduga ji,, it will helpful for us

Quite informative

You are rock man...good explain in very simple language and example

82k view 😂

Video ok but voice very low

thank u bro clean explanation

When to use view and materialized view ?

you videos are good but volume is very low , we have to keep 100 then ony can hear you properly .

Thank you very much for the great content! Could tell me where could I find the Video related to last part of the video? (about the question: in which scenarios should we use wich concept)

why do we need materialized view ?

my doubts are all clear, thanks

Thank for clarification ... Bless you

Nice explanation. Few points to add- 1. While creating Mviews, internal tables and index are created in same schema along with mview. 2. We can have partitions and indexes for mviews.

Clear Explanation. sir

Very Informative and Clear Explanation... Thank you so much Siva.. Keep up the Good work !!!

Hello sir...
Can we perform dml statement in base table through view??

Excellent teaching of Concept sir,. Keep it on, best wishes

ora - 12015 cannot create a fast refresh materialized view from a complex query
Cause: Neither ROWIDs and nor Primary key constraints are supported for complex queries..Plz make one video on this topic

Thank u

Sir, Could you please answer this question- why we are going for a Materialized? I mean as view doesn't store any data so there will not be any space issue but Materialized view stores data in a physical memory location so it will take space then also use Materialized view why?

Thank so much sir, cristal clear explanation.. ❤️

On performance basic is mv is used if there is frequent dml operation?

Best explanation I found on internet. Thank You.

👌

Great👍🤟

What is the difference between view and synonyms?

Hi Sir,
Please make tutorial on MV... refresh types etc.,

Best explaination till date.

Can u make video on below question

Sir can u make difference between group by and partition by????

If materialised views have their separate physical storage then why shld v not create a subset of the main table, why a materialised view only ! If u may answer pls .

Thank you very much for sharing your knowledge...If am not wrong need below correction. For point no 2. in comparison of View and MV @9.55. For view, online data from underlying base tables and for MV it should be Offline/delayed data from MV instead of underlying base tables as last refresh data is returned...

Very informative video. Most of the videos voice is low. Hope it will be taken care

Hi please post separate video on materlized view.... Refresh methods.