Archive for the ‘SQL’ Category

1 模糊查询like ‘%XX%’ 的优化一例

Posted in DBA, SQL,
2008-09-19,
74 views,Comments2008-09-19+06%3A47%3A33skywalker
2 等待事件相关的SQL

Posted in DBA, SQL,
2008-07-30,
31 views,Comments2008-07-30+05%3A16%3A36skywalker
Tags: DBA, oracle, session_wait, SQL, 等待事件
3 ORACLE STATSPACK REPORT输出结果说明

Posted in DBA, SQL,
2008-04-21,
34 views,Comments2008-04-21+04%3A10%3A45skywalker
Tags: oracle, statspack
4 用sql截取字符串

Posted in SQL,
2007-11-07,
234 views,Comments2007-11-07+05%3A28%3A18skywalker
5 一道有意思的sql题

Posted in SQL,
2007-11-06,
22 views,Comments2007-11-06+07%3A41%3A47skywalker
6 Oracle分析函数参考手册

Posted in SQL,
2007-03-13,
23 views,Comments2007-03-13+00%3A32%3A55skywalker