Answer Posted / raj dhar
View is a vertual table and it does not occupy the space.
And the types of views are:-
1)Simple View
2)Complex View
3)Force View
4)Inline View
5)Read Only View
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is snapshot is too old? Give and example for better understand.
How to start your 10g xe server from command line?
How to connect to oracle using service name instead of sid?
How to check the oracle tns settings?
How do I connect to oracle database?
What are the predefined tablespaces in a database?
What exactly do quotation marks around the table name do?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to assign query results to variables?
Is the After report trigger fired if the report execution fails ?
How to apply filtering criteria at group level in oracle?
What is coalesce function?
How to define an anonymous procedure with variables?
What is the maximum number of triggers that can be applied to a single table?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.