<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[winie]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/iteye_15057</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; iteye_15057]]></copyright><item><title><![CDATA[Merge into bug？]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82583984</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82583984</guid><author>iteye_15057</author><pubDate>Wed, 02 Jul 2014 10:54:59 +0800</pubDate><description><![CDATA[
在ORACLE 11.2.0.3上执行merge into 里面sql 入下形式：
merge into DCDW.t1 Target
    using (select Org_code Org_code,
                  BUSS_DATE,
                  BUSS_NO,
                 ...
          ...]]></description><category></category></item><item><title><![CDATA[AWR 报告关键部分]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82582009</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82582009</guid><author>iteye_15057</author><pubDate>Mon, 09 Jun 2014 10:38:40 +0800</pubDate><description><![CDATA[
1、后台等待事件
2、按Gets排序的SQL
3、按读取次数排序的SQL
4、按物理读取排序的SQL
5、实例活动统计
6、日志切换
7、队列活动
8、表空间、数据文件和SQL语句的读取
9、表扫描的数据段
10、行锁等待的数据段
11、撤销段小结
...]]></description><category></category></item><item><title><![CDATA[DBLinks 新增加字段后，提示标识符无效]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82581832</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82581832</guid><author>iteye_15057</author><pubDate>Fri, 06 Jun 2014 15:03:10 +0800</pubDate><description><![CDATA[
     在用DBlinks同步数据中，原表和目标表增加了字段，出现：Body 1193 36 PL/SQL: ORA-00904: &quot;SOURCE&quot;.&quot;****&quot;: 标识符无效，一直困扰着，今天突然感觉是缓存问题，在目标库执行：ALTER SYSTEM FLUSH SHARED_POOL;
再重新编译，哈哈，提示成功了。不过此方式在生产环境谨慎使用，必定会增加共享sql的解析。请在非高峰期...]]></description><category></category></item><item><title><![CDATA[PostgreSQL实用SQL]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82576636</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82576636</guid><author>iteye_15057</author><pubDate>Tue, 15 Apr 2014 17:04:00 +0800</pubDate><description><![CDATA[--查看数据库
select * from pg_database;


--查看表空间
select * from pg_tablespace;


--查看语言
select * from pg_language;


--查看角色用户
select * from pg_user;
select * from pg_shadow;
select * from pg_roles;


--查看会...]]></description><category></category></item><item><title><![CDATA[oracle中，行转列函数wm_concat()结果有长度限制，重写该函数解决]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82576602</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82576602</guid><author>iteye_15057</author><pubDate>Tue, 15 Apr 2014 14:34:00 +0800</pubDate><description><![CDATA[--Type
CREATE OR REPLACE TYPE yxwsp.zh_concat_im   AS OBJECT
(
  CURR_STR clob,
  STATIC FUNCTION ODCIAGGREGATEINITIALIZE(SCTX IN OUT zh_concat_im)
    RETURN NUMBER,
  MEMBER FUNCTION ODCIAGGREGATEIT...]]></description><category></category></item><item><title><![CDATA[Oracle: Automatic Subprogram Inlining]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82576596</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82576596</guid><author>iteye_15057</author><pubDate>Tue, 15 Apr 2014 13:38:00 +0800</pubDate><description><![CDATA[


Every call to a procedure or function causes a slight, but measurable, performance overhead, which is especially noticeable when the subprogram is called within a loop. Avoiding procedures and fu...]]></description><category></category></item><item><title><![CDATA[Oracle:Dynamic SQL Enhancements]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82576594</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82576594</guid><author>iteye_15057</author><pubDate>Tue, 15 Apr 2014 13:37:00 +0800</pubDate><description><![CDATA[   Native dynamic SQL and the DBMS_SQL package now support dynamic SQL statements larger than 32 KB. TheEXECUTE
 IMMEDIATEstatement,OPEN-FORstatement
 andDBMS_SQL.PARSEprocedure
 all accept SQL sta...]]></description><category></category></item><item><title><![CDATA[ORALCE 的字符串转换为列表]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82576593</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82576593</guid><author>iteye_15057</author><pubDate>Tue, 15 Apr 2014 13:36:00 +0800</pubDate><description><![CDATA[select regexp_substr('SMITH,ALLEN,WARD,JONES', '[^,]+', 1, level) from dualconnect by regexp_substr('SMITH,ALLEN,WARD,JONES', '[^,]+', 1, level) is not null]]></description><category></category></item><item><title><![CDATA[动态SQL、绑定变量、静态SQL的性能对比]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82576592</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82576592</guid><author>iteye_15057</author><pubDate>Tue, 15 Apr 2014 13:35:00 +0800</pubDate><description><![CDATA[
   测试样例

下面的三个存储过程，分别使用了动态SQL、绑定变量、静态SQL三种编程方式。具体存储过程内容如下：

l动态SQL

create or replace procedure proc1 as

begin

for i in 1 .. 100000 loop

  execute immediate 'insertinto t values (' ||...]]></description><category></category></item><item><title><![CDATA[数据库出现 enq: TX - row lock contention]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82576582</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82576582</guid><author>iteye_15057</author><pubDate>Tue, 15 Apr 2014 11:47:00 +0800</pubDate><description><![CDATA[数据库出现 enq: TX - row lock contention
今天上午过来，做awr报告数据库出现了很多enq: TX - row lock contention的等待事件，以前从来没有过的，感觉很奇怪。查询gv$session中的等待事件



[sql]view
 plaincopy






scrac1/sys@JSCN&amp;gt;selectevent,c...]]></description><category></category></item><item><title><![CDATA[Oracle估算表大小的小方法]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82576457</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82576457</guid><author>iteye_15057</author><pubDate>Mon, 14 Apr 2014 16:00:00 +0800</pubDate><description><![CDATA[
查看了一下ALL_TABLES 表，其中有个字段：avg_row_len. 该值单位为bytes。 可以一句这个字段来进行一个估算。

AVG_ROW_LEN*NUMBERAverage length of a row in the table (in bytes)http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/...]]></description><category></category></item><item><title><![CDATA[[MySQL FAQ]系列 -- 新手必看：一步到位之InnoDB]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82575887</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82575887</guid><author>iteye_15057</author><pubDate>Thu, 10 Apr 2014 11:51:00 +0800</pubDate><description><![CDATA[
作/译者：叶金荣（imysql#imysql.com&amp;gt;），来源：http://imysql.com，欢迎转载。

前言：MySQL发展到今天，InnoDB引擎已经作为绝对的主力，除了像大数据量分析等比较特殊领域需求外，它适用于众多场景。然而，仍有不少开发者还在“执迷不悟”的使用MyISAM引擎，觉得对InnoDB无法把握好，还是MyISAM简单省事，还能支持快速COUNT(*)。本文...]]></description><category></category></item><item><title><![CDATA[PowerDesigner 之 report html]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82575718</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82575718</guid><author>iteye_15057</author><pubDate>Wed, 09 Apr 2014 12:04:00 +0800</pubDate><description><![CDATA[谁说的PowerDesigner 导出的Html不好看？在相对于ERwin建模，我觉得PD更好用，在表设置上，er图的调整上，字段的选择上等都挺好用的，erwin我觉得优势在report上，其他并未发现特别的优势，这是用erwin一年来的感慨，erwin在很多上造成了重复劳动。一个顺手的工具是一个工作的一个好帮助！...]]></description><category></category></item><item><title><![CDATA[Oracle之行转列]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/82575225</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/82575225</guid><author>iteye_15057</author><pubDate>Fri, 04 Apr 2014 14:53:40 +0800</pubDate><description><![CDATA[
select regexp_substr(in_code_key,
                                 '[^' || v_delimiter || ']+',
                                 1,
                                 level) code_key
              ...]]></description><category></category></item><item><title><![CDATA[mysql  不能使用别名]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/81933552</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/81933552</guid><author>iteye_15057</author><pubDate>Sat, 09 Oct 2010 12:10:35 +0800</pubDate><description><![CDATA[MySQL版本5.0insert  delete 操作是不允许使用表别名的。update  where条件中不允许自连接update test set id=1 where pid in(select id from test where pid=12); 是不允许的。
 
解决办法：
 
  update `a` as `c1`, `a` as `c2` set `c1`.`id` = ...]]></description><category></category></item><item><title><![CDATA[导出oracle数据出txt  第一版本]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/81895919</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/81895919</guid><author>iteye_15057</author><pubDate>Sat, 24 Jul 2010 14:06:29 +0800</pubDate><description><![CDATA[ perl  做的导出oracle数据库文本第一本版出现此版本 来自网络 进行修改而完成  以后打算完善版本和功能。]]></description><category></category></item><item><title><![CDATA[MongoDB 初看]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/81892096</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/81892096</guid><author>iteye_15057</author><pubDate>Tue, 13 Jul 2010 09:24:32 +0800</pubDate><description><![CDATA[MongoDB  数据库在粗略看了下。感觉此数据库并非sql 非关系数据库，即nosql 。在数据存储和获取感觉和json数据很相似。呵呵。。很多大型网站已经开始使用nosql处理大型并非的请求。有机会得学习下nosql数据库。...]]></description><category></category></item><item><title><![CDATA[用 Oracle 数据库 10g 通过回收浪费的空间、联机重组表格和评估增长的趋势，有效地在段中进行存储管理...]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/81886726</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/81886726</guid><author>iteye_15057</author><pubDate>Tue, 22 Jun 2010 14:45:22 +0800</pubDate><description><![CDATA[近来，有人要求我评估一个与 Oracle 数据库竞争的 RDBMS。在供应商的演示过程中，观众认为“最棒”的特性是，对联机重组的支持 — 该产品可以联机重新部署数据块，以使段的等价物更简洁，并且不会影响当前的用户。 
 
那时，Oracle 还没有在 Oracle9i 数据库中提供这种功能。但是现在，有了 Oracle 数据库 10g，就可以轻松地联机回收浪费的空间和压缩对象—正好适合于起步者...]]></description><category></category></item><item><title><![CDATA[在Oracle中实现时间相加处理]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/81886449</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/81886449</guid><author>iteye_15057</author><pubDate>Mon, 21 Jun 2010 15:46:33 +0800</pubDate><description><![CDATA[在Oracle中实现时间相加处理
　　-- 名称：Add_Times
　　-- 功能：返回d1与NewTime相加以后的结果，实现时间的相加
　　-- 说明：对于NewTime中的日期不予考虑
　　-- 日期：
　　-- 版本：1.0
　　-- 作者：
　　create or replace function Add_Times(d1 in date,NewTime in date)...]]></description><category></category></item><item><title><![CDATA[如何使用DWR2.0的注解功能]]></title><link>https://blog.youkuaiyun.com/iteye_15057/article/details/81883304</link><guid>https://blog.youkuaiyun.com/iteye_15057/article/details/81883304</guid><author>iteye_15057</author><pubDate>Wed, 09 Jun 2010 13:49:45 +0800</pubDate><description><![CDATA[
DWR2.0新增加了JDK5的注解(Annotation)功能，使用注解功能之后可以从很大程度上简化了原来的dwr.xml的配置，使用起来非常的方便。
一、配置DWR使用注解功能
如果让dwr使用注解功能需要在web.xml进行如下配置：

&amp;lt;servlet&amp;gt; 
&amp;lt;servlet-name&amp;gt;dwr-invoker&amp;lt;/servlet-name&amp;gt; 
&amp;l...]]></description><category></category></item></channel></rss>