 Related Questions Latest Answer : A view is a named query. It is “a tailored presentation of the data contained in one or more tables (or other views).” For SQL, view = a named or derived virtual table • For users, view = a table (which in fact does not exist!) • ... Latest Answer : No, it does not contain own data ... Latest Answer : Yes a view can be based on another view. For example data dictionary views can be used to create another view in order to improve better access. ... select segment_name,sum(bytes) from dba_segmentswhere segment_name='TABLE_NAME' AND OWNER='OWNER of the table'group by segment_name Latest Answer : and adding to the previous...view are not physical entities like tables which occupy space in the database..they are logical and whenever you select, the query underlying the view gets fired and results are returned. Hence, you cannot get the space information ... The primary functional difference between logical and physical standby database setups is that logical standby permits you to add additional objects (tables, indexes, etc) to the database, while physical Latest Answer : A physical or logical standby database is a database replica created from a backup of a primary database. A physical standby database is physically identical to the primary database on a block-for-block basis. It's maintained in managed ... This is extract from Oracle10g Advanced Replication Book. How Materialized Views Work with Object Types and CollectionsOracle object types are user-defined datatypes that make it possible to model complex Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns Latest Answer : select * from v$parameter where name='spfile'; ... Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for View Question | Asked by : David Latest Answer : snapshots can't upated. While MV can be updated contantley. ... Read Answers (2) | Asked by : sanju` What is the difference between Cost Based Optimizer and Rule Based Optimizer?(CBO is the default optimizer) Latest Answer : In brief the rule-based method means that when executing a query the database must follow certain predefined rules and matter what data is stored in affected database tables. The cost-based method means the database must decide which query execution plan ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
