<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[zhuzhiming_Ming的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/zhuzhiming_Ming</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; zhuzhiming_Ming]]></copyright><item><title><![CDATA[Oracle11g 日志存放路径查询]]></title><link>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/106259947</link><guid>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/106259947</guid><author>zhuzhiming_Ming</author><pubDate>Thu, 21 May 2020 16:02:07 +0800</pubDate><description><![CDATA[--显示DIAGNOSTIC_DEST的位置

1.show parameter DIAGNOSTIC_DEST;

--查询xml文件的目录

2.select value from v$diag_info where name='Diag Alert';



--查询文本文件的目录

3.select value from v$diag_info where name='Diag Trace';



4.show parameter background_dump_dest;



5.sel...]]></description><category></category></item><item><title><![CDATA[in字段达到上限]]></title><link>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/86489529</link><guid>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/86489529</guid><author>zhuzhiming_Ming</author><pubDate>Tue, 15 Jan 2019 11:17:57 +0800</pubDate><description><![CDATA[将SQL语句 id In（'a1',...........）转换成

id  in('a1'.....,'a999')  or   id in('a999'.......) or...

代码如下：

/**
     * 因in长度限制转换sql
     * @param id 字段名称
     * @param list 数据集
     * @return
     */
    pub...]]></description><category></category></item><item><title><![CDATA[Oracle split函数，in字符串，列转行]]></title><link>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/86488377</link><guid>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/86488377</guid><author>zhuzhiming_Ming</author><pubDate>Tue, 15 Jan 2019 10:34:31 +0800</pubDate><description><![CDATA[创建函数：

CREATE OR REPLACE
function split(p_str varchar2,p_delimiter varchar2 default ',') return type_str
is
  rs type_str:=type_str();
  l_str varchar2(4000):='';
  l_len number:=0;
begin
  l_str:=p_s...]]></description><category></category></item><item><title><![CDATA[Oracle行转列和Clob字段属性大数据行转列，Clob转字符串]]></title><link>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/86487824</link><guid>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/86487824</guid><author>zhuzhiming_Ming</author><pubDate>Tue, 15 Jan 2019 10:22:33 +0800</pubDate><description><![CDATA[行转列：

concat函数：

select wmsys.wm_concat(column) from test group id;

listagg函数：

select listagg(name,',')within group(order by age)name from emp;

 

Clob行转列：

拼接起来以“,”分割：

select XMLAGG(XMLELEMENT(E,...]]></description><category></category></item><item><title><![CDATA[flume 官方文档]]></title><link>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/80022064</link><guid>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/80022064</guid><author>zhuzhiming_Ming</author><pubDate>Fri, 20 Apr 2018 17:44:28 +0800</pubDate><description><![CDATA[http://flume.apache.org/releases/content/1.8.0/]]></description><category></category></item><item><title><![CDATA[数据库重复数据不录入]]></title><link>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/79758983</link><guid>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/79758983</guid><author>zhuzhiming_Ming</author><pubDate>Fri, 30 Mar 2018 16:04:24 +0800</pubDate><description><![CDATA[数据库用的是Mysql把某字段设置为unique（唯一的）。    serviceId varchar(255) unique 在方法,interface,mapper中方法抛出EXCEPTION。    int save(A a) throws Exception在调用地方捕获异常判断类型是否为MySqlIntegrityConstraintViolationExceptiontry {
   ...]]></description><category></category></item><item><title><![CDATA[佛祖保佑代码]]></title><link>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/79678616</link><guid>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/79678616</guid><author>zhuzhiming_Ming</author><pubDate>Sat, 24 Mar 2018 15:50:17 +0800</pubDate><description><![CDATA[ 1 //                                                          _ooOoo_
 2 //                                                         o8888888o
 3 //                                                    ...]]></description><category></category></item><item><title><![CDATA[JDK 10下载]]></title><link>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/79671329</link><guid>https://blog.youkuaiyun.com/zhuzhiming_Ming/article/details/79671329</guid><author>zhuzhiming_Ming</author><pubDate>Fri, 23 Mar 2018 18:45:59 +0800</pubDate><description><![CDATA[网盘链接 ： https://pan.baidu.com/s/1rct48SfqHzBYymzCIH6Mtw]]></description><category></category></item></channel></rss>