What is the differnce between view and materialized view
Answer Posted / yaswanth
A view will takes the output of the query. But a materialized
view stores the output of the query which is not possible in
view
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
how to extract a unit value from a date and time? : Sql dba
what is blob? : Sql dba
What is the difference between a procedure and a function?
What are different methods to trace the pl/sql code?
What does <> sql mean?
What is set serveroutput on?
Why is the cursor important?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
what is sub-query? : Transact sql
What is use of trigger?
Can there be more than one function with a similar name in a pl/sql block?
What are all ddl commands?
How do you respond to dementia behavior?
define data blocks ? : Sql dba
Why do we need cursor in pl sql?