- 博客(8)
- 收藏
- 关注
RSS订阅转载 Oracle参数小结
一. 普通参数 SELECT num,name,value,isdefault FROM v$parameter; [@more@]Isdefault : Indicates ...
2008-05-19 14:14:07
80
转载 How to make CBO use Index Skip Scan
Create a concatenated index on table ITEM.[@more@] SQL> create index idx_item on item(create_by,item...
2007-12-24 16:29:07
89
转载 Using some data dictionary views in PLSQL with ORA-00942 occuring
When you try to use some data dictionary views such as v$, dba_ in a procedure, you may receive an error “ORA-...
2007-11-06 16:41:52
98
转载 Oracle 10g New Features - AWR - Basical Conception
1. What is AWR?[@more@] AWR stands for “Automatic Workload Repository“, which installs along with the d...
2007-11-05 15:48:16
112
转载 史上最强的几道oracle面试题
在ctocio.com.cn上看到3道Oracle面试题，据说如果10分钟内能够全部回答正确，就说明你应该具备一个OCP所具有的思考能力。看似可以脱口而出的答案，在仔细思考后发现自己最开始的答案都不对，晕啊！下面是题，答案是...
2007-10-17 12:07:42
117
转载 NULL是不可被比较的
现象：[@more@]SQL> select * from bundle 2 where deactivate_date >= to_date('1000-01-01','yyyy-mm-dd') AND de...
2007-10-11 10:37:24
114
转载 BI项目中ETL设计与思考(转)
BI项目中ETL设计与思考(本文转自http://database.ctocio.com.cn/tips/409/7160909_2.shtml)[@more@] ETL即数据抽取（Extract）、转换（Transfor...
2007-10-08 17:39:47
102
转载 Oracle 临时表
Oracle Temporary Tables[@more@]1. 建立语法A．ON COMMIT DELETE ROWS 定义了建立事务级临时表的方法CREATE GLOBAL TEMPORARY TABLE TAB...
2007-09-29 17:26:36
55
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人