<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[navysuning的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/navysuning</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; navysuning]]></copyright><item><title><![CDATA[比较两个表的数据   优化]]></title><link>https://blog.youkuaiyun.com/navysuning/article/details/50456715</link><guid>https://blog.youkuaiyun.com/navysuning/article/details/50456715</guid><author>navysuning</author><pubDate>Mon, 04 Jan 2016 16:19:19 +0800</pubDate><description><![CDATA[CREATE OR REPLACE PROCEDURE prc_data_chk03_tmp AS


BEGIN
  execute immediate 'truncate table polreg.rev_data_chk03';
       insert into polreg.rev_data_chk03 (transactionno, tab_name, busstype, ]]></description><category></category></item><item><title><![CDATA[存储过程比较两个标的数据  优化]]></title><link>https://blog.youkuaiyun.com/navysuning/article/details/50456697</link><guid>https://blog.youkuaiyun.com/navysuning/article/details/50456697</guid><author>navysuning</author><pubDate>Mon, 04 Jan 2016 16:16:53 +0800</pubDate><description><![CDATA[CREATE OR REPLACE PROCEDURE prc_data_chk03_tmp AS


BEGIN
  execute immediate 'truncate table polreg.rev_data_chk03';
 
       insert into polreg.rev_data_chk03 (transactionno, tab_name, busstyp]]></description><category></category></item><item><title><![CDATA[存储过程，比较两个表的数据]]></title><link>https://blog.youkuaiyun.com/navysuning/article/details/50434154</link><guid>https://blog.youkuaiyun.com/navysuning/article/details/50434154</guid><author>navysuning</author><pubDate>Wed, 30 Dec 2015 13:53:25 +0800</pubDate><description><![CDATA[--存储过程
  --POL_REG_LCPOLTRANSACTION分别与POL_REG_LCCONT，POL_REG_LCPRODINSURELA，POL_REG_LCPRODUCT，POL_REG_LCBNF比较
  CREATE OR REPLACE PROCEDURE prc_liuhaijun01 AS
  cnt_a NUMBER;
  cnt_b NUMBER;
  cn]]></description><category></category></item></channel></rss>