<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cks26790的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cks26790</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cks26790]]></copyright><item><title><![CDATA[oracle，使用model补全中间空缺数字]]></title><link>https://blog.youkuaiyun.com/cks26790/article/details/100222628</link><guid>https://blog.youkuaiyun.com/cks26790/article/details/100222628</guid><author>cks26790</author><pubDate>Wed, 22 May 2019 17:15:23 +0800</pubDate><description><![CDATA[with t as(select 2 n,'tom' name from dual union all select 4,'tom' from dual union all select 7,'tom' from dual...]]></description><category></category></item><item><title><![CDATA[vue.js与后台模板引擎“双花括号”冲突]]></title><link>https://blog.youkuaiyun.com/cks26790/article/details/100222625</link><guid>https://blog.youkuaiyun.com/cks26790/article/details/100222625</guid><author>cks26790</author><pubDate>Wed, 13 Feb 2019 10:57:23 +0800</pubDate><description><![CDATA[新建时添加delimiters,比如将"{{ }}"改为"[{ }]"



new Vue({


delimiters:['[{','}]'],







})

  ...]]></description><category></category></item><item><title><![CDATA[dbms_sql]]></title><link>https://blog.youkuaiyun.com/cks26790/article/details/100222633</link><guid>https://blog.youkuaiyun.com/cks26790/article/details/100222633</guid><author>cks26790</author><pubDate>Tue, 22 Nov 2016 16:18:38 +0800</pubDate><description><![CDATA[看了一天dbms_sql包，写了个导出csv的代码加深对dbms_sql的理解，虽然用developer工具很容易实现.

建directory
create directory abc_dir as 'c:\abc';...]]></description><category></category></item><item><title><![CDATA[用model写的一个统计]]></title><link>https://blog.youkuaiyun.com/cks26790/article/details/100222626</link><guid>https://blog.youkuaiyun.com/cks26790/article/details/100222626</guid><author>cks26790</author><pubDate>Wed, 09 Nov 2016 10:25:15 +0800</pubDate><description><![CDATA[with t as(SELECT to_date('20160101','yyyy-mm-dd') d_day,1id_no,3trans_time FROM dual UNION ALL
SELECT to_date('20...]]></description><category></category></item><item><title><![CDATA[字符串分割行转列]]></title><link>https://blog.youkuaiyun.com/cks26790/article/details/100222624</link><guid>https://blog.youkuaiyun.com/cks26790/article/details/100222624</guid><author>cks26790</author><pubDate>Mon, 07 Nov 2016 15:50:58 +0800</pubDate><description><![CDATA[with t(id,str) as(select 1,'11,12,13,14' from dual union all select 2,'21,22,23' from dual)

方法1，
select id,reg...]]></description><category></category></item><item><title><![CDATA[oracle自定义异常]]></title><link>https://blog.youkuaiyun.com/cks26790/article/details/100222620</link><guid>https://blog.youkuaiyun.com/cks26790/article/details/100222620</guid><author>cks26790</author><pubDate>Thu, 13 Oct 2016 10:02:07 +0800</pubDate><description><![CDATA[不声明异常，使用使用raise_application_error抛出只有错误数字(-20999，-20000)和错误信息的异常,不能通过名称捕获,可以通过错误的数字得到自定义的异常信息。
declare
 v_bool ...]]></description><category></category></item></channel></rss>