SQL> desc dual
SQL> select * from dual;
D
-
X
下面使用dual执行一个算数操作:
SQL> select 1+2*5 from dual;
----------
注意:
从Oracle Database 10g Release1,当计算表达式不包括DUMMY列时,在dual表不会执行逻辑I/O。如果查询DUMMY列,则会产生逻辑I/O.
例如:
SQL> set linesize 132
SQL> set autotrace traceonly
SQL> select 1+2*5 from dual;
Execution Plan
----------------------------------------------------------
Plan hash value: 1388734953
-----------------------------------------------------------------
| Id
-----------------------------------------------------------------
|
|
-----------------------------------------------------------------
Statistics
----------------------------------------------------------
SQL> select * from dual;
Execution Plan
----------------------------------------------------------
Plan hash value: 272002086
--------------------------------------------------------------------------
| Id
--------------------------------------------------------------------------
|
|
--------------------------------------------------------------------------
Statistics
----------------------------------------------------------