 Related Questions Latest Answer : Following this as an example let us see how the select execution happens in
database.
SELECT ename,sal,job FROM emp
WHERE job='clerk'
ORDER BY sal;
How does the query execution occur?
SQL*plus checks the syntax on client side.
If syntax ... Read Answers (8) | Asked by : SaratKumar Latest Answer : First you have to understand that Oracle is a MVCC (multiversion concurrency control) or "repeatable read" database system. Queries are returned with all rown consistent with respect to the point in time (SCN) you bagan the query (or earlier with "flashback ... Read Answers (6) | Asked by : SaratKumar View Question | Asked by : SaratKumar Latest Answer : A materialized view (MV) is similar to a view but the data is actually stored on disk (view that materializes). Materialized views are often used for summary and pre-joined tables, or just to make a snapshot of a table available on a remote system. A ... Read Answers (8) | Asked by : rekha Latest Answer : 8i-materilized views, instead of triggers, support internet, granting of columns
9i-timestamp, rename of column, new datatypes, rank, dense_rank, 9i joins ... Read Answers (9) | Asked by : Reddeppa When i type 'ed' or 'edit' in oracle i did n't presented by any editor,what is the problem? In oracle we are using dual table name for the temporary purpose. which table we are using in SQL server Latest Answer : V$backup : This status column of this view shows whether a tablespace in hot backup mode.The status 'ACTIVE' shows the datafile to be in backup mode.V$datafile_header : The fuzzy column also helps a dba to monitor datafile which are in backup mode. ... Read Answers (1) | Asked by : Deep Chandra Padey Tags : Backup Latest Answer : hello dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. sql> desc dualName Null? ... Latest Answer : Snapshot and materialized view are almost same same but with one difference.You can say that materialized view =snapshot + query rewrite functionalityquery rewrite functionality:In materialized view you can enable or disable query rewrite option. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
