What is the differnce between view and materialized view
Answer Posted / nivedita
view is a virtual table.view does not contain any data
while material view has its own data.material views are the
local copies of remote data.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Which software is used for pl sql programming?
What is cursor in pl sql with examples?
What is the importance of sqlcode and sqlerrm?
How many types of triggers are there in pl sql?
What is the difference between the conventional and direct path loads? : aql loader
What are the advantages of stored procedure?
What is database migration?
Explain clause in sql?
Can I call a procedure inside a function?
Why is normalization important?
who introduced sql?
Determine if oracle date is on a weekend?
Is sql a microsoft product?
what is the difference between a local and a global temporary table? : Sql dba
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..