Answer Posted / lokanath
View is basically a Stored Query. we can call it as Logical
representaion of table. View Doesnot contain data. But
Materialized view Contains data. Because Materialised view
contains results of a Query.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Explain an integrity constrains?
Can you drop an index associated with a unique or primary key constraint?
How to build data dictionary view an new database?
How do I limit the number of oracle database connections generated by weblogic server?
How to get the Installed Oracle Version Information ?
How to define a record variable to store a table row?
Can sub procedure/function be called recursively?
Difference between the “verify” and “feedback” command?
What is SQL Tuning Advisor in Oracle?
Can group functions be used in the order by clause in oracle?
When system tablespace is created?
What to do if dba lost the system password?
What is the sql query to concatenate column values from multiple rows in oracle?
What is an oracle database?
Why is oracle used?