构建虚拟表简析
构建虚拟表简析项目中为了减少I/O流,采用构建虚拟表的方法来显示特殊的数据:
如达到下面的效果:
SQL代码:
[html] select '1' as ID,'高' as 等级 from dual union all select '2','中' from dual union all select '3','低' from dual;
[html] select '1' as ID,'高' as 等级 from dual union all select '2','中' from dual union all select '3','低' from dual;
上一个:oracle正常关闭下redo丢失恢复
下一个:oracle之临时表空间组