Oracle到PostgreSQL等價改寫
直奔主題,原SQL是這樣的,在Oracle系統上比較快便執行出來了,執行計劃和SQL文字如下
select a.prd_code, a.targ_prd_code, a.seller_code, a.share_class, a.c_targetsharetype from fund60trans1.tbfundcfmexptmp1_3 a, tbfundchangelimit b where (a.prd_code = b.prd_code or b.prd_code = '*') and (a.share_class = b.share_class or b.share_class = '*') and (a.seller_code = b.seller_code or b.seller_code = '*') and (a.targ_prd_code = b.targ_prd_code or b.targ_prd_code = '*') and (a.c_targetsharetype = b.targ_share_class or b.targ_share_class = '*');
執行到PostgreSQL上走nested loop join遲遲不出結果,執行計劃如下
強制走hash join呢?
指定此 hint /*+hashjoin(a b) parallel(a 2 hard) parallel(b 3 hard)*/,看到這種情況 PostgreSQL還是不走hash join的,因為條件中有or,有or的情況優化器是走不了hash join,看cost 100000000000,PostgreSQL認為走nested loop cost無限大,但是他又不能走hash join和merge join,只能不得不走nested loop,那麼如上這種sql對於postgresql來講變無能為力了
改SQL
SELECT vm_tmp.ITEM_1 PRD_CODE, vm_tmp.ITEM_2 TARG_PRD_CODE, vm_tmp.ITEM_3 SELLER_CODE, vm_tmp.ITEM_4 SHARE_CLASS, vm_tmp.ITEM_5 C_TARGETSHARETYPE FROM ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND B.SHARE_CLASS = '*' AND B.SELLER_CODE = '*' AND B.TARG_PRD_CODE = '*' AND B.TARG_SHARE_CLASS = '*') UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND B.SHARE_CLASS = '*' AND B.SELLER_CODE = '*' AND B.TARG_PRD_CODE = '*' AND B.TARG_SHARE_CLASS = '*' AND lnnvl(B.PRD_CODE = '*')) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND A.SHARE_CLASS = B.SHARE_CLASS AND B.SELLER_CODE = '*' AND B.TARG_PRD_CODE = '*' AND B.TARG_SHARE_CLASS = '*' AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND B.SHARE_CLASS = '*' AND A.SELLER_CODE = B.SELLER_CODE AND B.TARG_PRD_CODE = '*' AND B.TARG_SHARE_CLASS = '*' AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND B.SHARE_CLASS = '*' AND B.SELLER_CODE = '*' AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND B.TARG_SHARE_CLASS = '*' AND lnnvl(B.TARG_PRD_CODE = '*') AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND B.SHARE_CLASS = '*' AND B.SELLER_CODE = '*' AND B.TARG_PRD_CODE = '*' AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND lnnvl(B.TARG_SHARE_CLASS = '*') AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND A.SHARE_CLASS = B.SHARE_CLASS AND B.SELLER_CODE = '*' AND B.TARG_PRD_CODE = '*' AND B.TARG_SHARE_CLASS = '*' AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*')) AND lnnvl(B.SHARE_CLASS = '*') AND lnnvl(B.PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND B.SHARE_CLASS = '*' AND A.SELLER_CODE = B.SELLER_CODE AND B.TARG_PRD_CODE = '*' AND B.TARG_SHARE_CLASS = '*' AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*')) AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*')) AND lnnvl(B.PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND B.SHARE_CLASS = '*' AND B.SELLER_CODE = '*' AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND B.TARG_SHARE_CLASS = '*' AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.TARG_PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND B.SHARE_CLASS = '*' AND B.SELLER_CODE = '*' AND B.TARG_PRD_CODE = '*' AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.PRD_CODE = '*') AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND A.SHARE_CLASS = B.SHARE_CLASS AND A.SELLER_CODE = B.SELLER_CODE AND B.TARG_PRD_CODE = '*' AND B.TARG_SHARE_CLASS = '*' AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND lnnvl(B.SELLER_CODE = '*') AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND A.SHARE_CLASS = B.SHARE_CLASS AND B.SELLER_CODE = '*' AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND B.TARG_SHARE_CLASS = '*' AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.TARG_PRD_CODE = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND A.SHARE_CLASS = B.SHARE_CLASS AND B.SELLER_CODE = '*' AND B.TARG_PRD_CODE = '*' AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND B.SHARE_CLASS = '*' AND A.SELLER_CODE = B.SELLER_CODE AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND B.TARG_SHARE_CLASS = '*' AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.TARG_PRD_CODE = '*') AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND B.SHARE_CLASS = '*' AND A.SELLER_CODE = B.SELLER_CODE AND B.TARG_PRD_CODE = '*' AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND B.SHARE_CLASS = '*' AND B.SELLER_CODE = '*' AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND lnnvl(B.TARG_PRD_CODE = '*') AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND A.SHARE_CLASS = B.SHARE_CLASS AND A.SELLER_CODE = B.SELLER_CODE AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND B.TARG_SHARE_CLASS = '*' AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND lnnvl(B.TARG_PRD_CODE = '*') AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND A.SHARE_CLASS = B.SHARE_CLASS AND A.SELLER_CODE = B.SELLER_CODE AND B.TARG_PRD_CODE = '*' AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND B.SHARE_CLASS = '*' AND A.SELLER_CODE = B.SELLER_CODE AND B.TARG_PRD_CODE = '*' AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND A.SHARE_CLASS = B.SHARE_CLASS AND B.SELLER_CODE = '*' AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND lnnvl(B.TARG_PRD_CODE = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND A.SHARE_CLASS = B.SHARE_CLASS AND B.SELLER_CODE = '*' AND B.TARG_PRD_CODE = '*' AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND B.SHARE_CLASS = '*' AND B.SELLER_CODE = '*' AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND lnnvl(B.TARG_PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS)) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND B.SHARE_CLASS = '*' AND A.SELLER_CODE = B.SELLER_CODE AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND lnnvl(B.TARG_PRD_CODE = '*') AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND B.SHARE_CLASS = '*' AND A.SELLER_CODE = B.SELLER_CODE AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND B.TARG_SHARE_CLASS = '*' AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.TARG_PRD_CODE = '*') AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND lnnvl(B.PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND A.SHARE_CLASS = B.SHARE_CLASS AND A.SELLER_CODE = B.SELLER_CODE AND B.TARG_PRD_CODE = '*' AND B.TARG_SHARE_CLASS = '*' AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND lnnvl(B.SELLER_CODE = '*') AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND lnnvl(B.PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND A.SHARE_CLASS = B.SHARE_CLASS AND B.SELLER_CODE = '*' AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND B.TARG_SHARE_CLASS = '*' AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND lnnvl(B.TARG_PRD_CODE = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE)) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND A.SHARE_CLASS = B.SHARE_CLASS AND A.SELLER_CODE = B.SELLER_CODE AND B.TARG_PRD_CODE = '*' AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.PRD_CODE = '*') AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.TARG_PRD_CODE = B.TARG_PRD_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE B.PRD_CODE = '*' AND A.SHARE_CLASS = B.SHARE_CLASS AND A.SELLER_CODE = B.SELLER_CODE AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND lnnvl(B.TARG_PRD_CODE = '*') AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.PRD_CODE = B.PRD_CODE) OR lnnvl(B.TARG_PRD_CODE = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND A.SHARE_CLASS = B.SHARE_CLASS AND A.SELLER_CODE = B.SELLER_CODE AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND B.TARG_SHARE_CLASS = '*' AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND lnnvl(B.PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND lnnvl(B.SHARE_CLASS = '*') AND lnnvl(B.TARG_PRD_CODE = '*') AND lnnvl(B.SELLER_CODE = '*') AND (lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS)) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND A.SHARE_CLASS = B.SHARE_CLASS AND B.SELLER_CODE = '*' AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.PRD_CODE = '*') AND lnnvl(B.TARG_PRD_CODE = '*') AND lnnvl(B.SHARE_CLASS = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE)) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.TARG_SHARE_CLASS = '*') AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SELLER_CODE = B.SELLER_CODE)) AND (lnnvl(A.SELLER_CODE = B.SELLER_CODE) OR lnnvl(B.TARG_SHARE_CLASS = '*'))) UNION ALL ((SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND B.SHARE_CLASS = '*' AND A.SELLER_CODE = B.SELLER_CODE AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.TARG_PRD_CODE = '*') AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND lnnvl(B.SELLER_CODE = '*') AND lnnvl(B.PRD_CODE = '*') AND lnnvl(B.TARG_SHARE_CLASS = '*') AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(A.SHARE_CLASS = B.SHARE_CLASS)) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(A.SHARE_CLASS = B.SHARE_CLASS) OR lnnvl(B.SELLER_CODE = '*'))) UNION ALL (SELECT A.PRD_CODE ITEM_1, A.TARG_PRD_CODE ITEM_2, A.SELLER_CODE ITEM_3, A.SHARE_CLASS ITEM_4, A.C_TARGETSHARETYPE ITEM_5 FROM TBFUNDCHANGELIMIT B, TBFUNDC3EXPTMP1 A WHERE A.PRD_CODE = B.PRD_CODE AND A.SHARE_CLASS = B.SHARE_CLASS AND A.SELLER_CODE = B.SELLER_CODE AND A.TARG_PRD_CODE = B.TARG_PRD_CODE AND A.C_TARGETSHARETYPE = B.TARG_SHARE_CLASS AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_PRD_CODE = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.SELLER_CODE = '*')) AND (lnnvl(B.PRD_CODE = '*') OR lnnvl(B.SHARE_CLASS = '*')) AND (lnnvl(B.SHARE_CLASS = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.TARG_PRD_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND (lnnvl(B.SELLER_CODE = '*') OR lnnvl(B.TARG_SHARE_CLASS = '*')) AND lnnvl(B.TARG_PRD_CODE = '*') AND lnnvl(B.PRD_CODE = '*') AND lnnvl(B.TARG_SHARE_CLASS = '*') AND lnnvl(B.SELLER_CODE = '*') AND lnnvl(B.SHARE_CLASS = '*'))))))))))))))))))))))))))))))))) vm_tmp;
26秒出結果
執行計劃預期與Oracle相同,前提SQL等價
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29990276/viewspace-2899686/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL的SQL等價改寫MySql
- PostgreSQL優化案例之 反連線與外連線等價改寫SQL優化
- SQL KEEP 視窗函式等價改寫案例SQL函式
- 異構資料庫遷移 sql等價改寫資料庫SQL
- Oracle case when改寫SQLOracleSQL
- Oracle Rownum分頁改寫Oracle
- 使用GoldenGate 遷移Oracle到PostgreSQL/LightDBGoOracleSQL
- SQL Server AlwaysOn的Oracle等價技術SQLServerOracle
- Oracle 到 PostgreSQL參考分割槽實現OracleSQL
- PostgreSQL 原始碼解讀(42)- 查詢語句#27(等價類)SQL原始碼
- Oracle vs PostgreSQL DBA(21)- Oracle VPDOracleSQL
- PostgreSQL批次改資料型別SQL資料型別
- Oracle vs PostgreSQL DBA(22)- Oracle VPD#2OracleSQL
- Oracle vs PostgreSQL Develop(17) - ARRAYOracleSQLdev
- Oracle vs PostgreSQL Develop(15) - DISTINCT ONOracleSQLdev
- Oracle vs PostgreSQL Develop(18) - BooleanOracleSQLdevBoolean
- PostgreSQL/Oracle 時間改成秒SQLOracle
- Oracle start with connect by PostgreSQL recursive cteOracleSQL
- PostgreSQL 原始碼解讀(44)- 查詢語句#29(等價類相關資料結構)SQL原始碼資料結構
- 從3分漲到8.5分,誰在改寫《原神》評分?
- PostgreSQL Oracle 相容性 - connect by 2SQLOracle
- Oracle vs PostgreSQL Develop(16) - Prepared StatementOracleSQLdev
- Oracle vs PostgreSQL Develop(20) - Materialized ViewOracleSQLdevZedView
- Oracle vs PostgreSQL Develop(19) - PIPE ROWOracleSQLdev
- PostgreSQL與Oracle的sql差異SQLOracle
- Oracle vs PostgreSQL Develop(28) - function overloadOracleSQLdevFunction
- Oracle vs PostgreSQL Develop(26) - ASCII 0OracleSQLdevASCII
- 多表關聯更新(mysql,oracle,postgreSQL)MySqlOracle
- Oracle vs PostgreSQL Develop(29) - COMMIT in PLSQLOracleSQLdevMIT
- 【pgupgrade】Postgresql10升級到Postgresql13SQL
- PostgreSQL編寫自定義extensionSQL
- ADT & OOP-等價性OOP
- 全球 1%人口患有自閉症,AI、VR等技術如何改寫它的治療方式AIVR
- Oracle與PostgreSQL比較:PostgreSQL至少在安裝和大小方面擊敗了Oracle - foersterOracleSQL
- Oracle vs PostgreSQL Develop(24) - subquery with agg functionOracleSQLdevFunction
- LightDB/PostgreSQL 相容Oracle儲存過程SQLOracle儲存過程
- Oracle vs PostgreSQL Develop(31) - Index Only ScanOracleSQLdevIndex
- PostgreSQL 13–改進後的基礎備份SQL