| SQL Id |
SQL Text |
|
1yr8ghjndt7cd |
select * from ( select jbxx0_.ID as col_0_0_, (to_xxdmzh('XB', jbxx0_.XB) ) as col_1_0_, (to_xxdmzh('ZJLX', jbxx0_.ZJLX) ) as col_2_0_, (to_xxdmzh('MZ', jbxx0_.MZ) ) as col_3_0_, (to_xxdmzh('HYZK', jbxx0_.HYZK) ) as col_4_0_, (to_xxdmzh('XZQH', jbxx0_.HJD) ) as col_5_0_, (to_xxdmzh('XZQH', jbxx0_.XZD) ) as col_6_0_, (to_xxdmzh('WHCD', jbxx0_.WHCD) ) as col_7_0_, (to_xxdmzh('SF', jbxx0_.SF) ) as col_8_0_, (to_xxdmzh('ZC', jbxx0_.ZC) ) as col_9_0_, (to_xxdmzh('GJ', jbxx0_.GJ) ) as col_10_0_, (to_xxdmzh('XZQH', jbxx0_.JG) ) as col_11_0_, (to_xxdmzh('ZZMM', jbxx0_.ZZMM) ) as col_12_0_, (to_xxdmzh('TSSF', trim(jbxx0_.TSSF)) ) as col_13_0_, (to_xxdmzh('ZY', jbxx0_.ZY) ) as col_14_0_, (to_xxdmzh('JKZK', jbxx0_.JKZK) ) as col_15_0_, (to_xxdmmultizh('AJLB', jbxx0_.AY) ) as col_16_0_, (to_xxdmzh('CYLX', jbxx0_.CYLX) ) as col_17_0_, (to_xxdmzh('BAJD', jbxx0_.BAHJ) ) as col_18_0_, (to_xxdmzh('RSXZ', jbxx0_.RSXZ) ) as col_19_0_, (to_xxdmzh('AJLB', jbxx0_.CAAJ) ) as col_20_0_, (to_xxdmzh('SYPZ', jbxx0_.SYPZ) ) as col_21_0_, (to_xxdmzh('DWLX', jbxx0_.DWLX) ) as col_22_0_, (select zdglobal1_.KVALUE from ZD_GLOBAL zdglobal1_ where zdglobal1_.KTYPE='AQDJ' and zdglobal1_.NUMKEY=jbxx0_.AQDJ) as col_23_0_, (to_xxdmzh('CSYY', jbxx0_.CSYY) ) as col_24_0_, (to_xxdmzh('CLJG', jbxx0_.CLJG) ) as col_25_0_, (to_xxdmzh('FJX', jbxx0_.FJX) ) as col_26_0_, jbxx0_.ID as ID28_, jbxx0_.AQDJ as AQDJ28_, jbxx0_.AY as AY28_, jbxx0_.AZB as AZB28_, jbxx0_.BADW as BADW28_, jbxx0_.BAHJ as BAHJ28_, jbxx0_.BAR as BAR28_, jbxx0_.BARJH as BARJH28_, jbxx0_.BHLX as BHLX28_, jbxx0_.BM as BM28_, jbxx0_.BMTY as BMTY28_, jbxx0_.BZ as BZ28_, jbxx0_.CAAJ as CAAJ28_, jbxx0_.CLJG as CLJG28_, jbxx0_.CREATETIME as CREATETIME28_, jbxx0_.CSQX as CSQX28_, jbxx0_.CSRQ as CSRQ28_, jbxx0_.CSSJ as CSSJ28_, jbxx0_.CSYY as CSYY28_, jbxx0_.CYLX as CYLX28_, jbxx0_.DAH as DAH28_, jbxx0_.DBRQ as DBRQ28_, jbxx0_.DH as DH28_, jbxx0_.DWLX as DWLX28_, jbxx0_.EMLX as EMLX28_, jbxx0_.FJX as FJX28_, jbxx0_.FZJL as FZJL28_, jbxx0_.GCBH as GCBH28_, jbxx0_.GJ as GJ28_, jbxx0_.GRJL as GRJL28_, jbxx0_.GYQX as GYQX28_, jbxx0_.GZDW as GZDW28_, jbxx0_.HJD as HJD28_, jbxx0_.HJDXZ as HJDXZ28_, jbxx0_.HX as HX28_, jbxx0_.HXQX as HXQX28_, jbxx0_.HYZK as HYZK28_, jbxx0_.JB as JB28_, jbxx0_.JG as JG28_, jbxx0_.JJ as JJ28_, jbxx0_.JKZK as JKZK28_, jbxx0_.JLRQ as JLRQ28_, jbxx0_.JSBH as JSBH28_, jbxx0_.JSH as JSH28_, jbxx0_.JSHJ as JSHJ28_, jbxx0_.JSLX as JSLX28_, jbxx0_.JSLY as JSLY28_, jbxx0_.JYAQ as JYAQ28_, jbxx0_.JYRQ as JYRQ28_, jbxx0_.LDF as LDF28_, jbxx0_.LSCSYY as LSCSYY28_, jbxx0_.LSFH as LSFH28_, jbxx0_.MZ as MZ28_, jbxx0_.OPERATOR as OPERATOR28_, jbxx0_.PWH as PWH28_, jbxx0_.RSRQ as RSRQ28_, jbxx0_.RSXZ as RSXZ28_, jbxx0_.RYBH as RYBH28_, jbxx0_.RYGLLB as RYGLLB28_, jbxx0_.SAVETIME as SAVETIME28_, jbxx0_.SCBZ as SCBZ28_, jbxx0_.SF as SF28_, jbxx0_.SG as SG28_, jbxx0_.SNBH as SNBH28_, jbxx0_.STATE as STATE28_, jbxx0_.SY as SY28_, jbxx0_ .SYDW as SYDW28_, jbxx0_.SYPZ as SYPZ28_, jbxx0_.SYPZWSH as SYPZWSH28_, jbxx0_.SYR as SYR28_, jbxx0_.TSBJ as TSBJ28_, jbxx0_.TSSF as TSSF28_, jbxx0_.WBRYBH as WBRYBH28_, jbxx0_.WHCD as WHCD28_, jbxx0_.WXDJ as WXDJ28_, jbxx0_.XB as XB28_, jbxx0_.XM as XM28_, jbxx0_.XMPY as XMPY28_, jbxx0_.XQ as XQ28_, jbxx0_.XZD as XZD28_, jbxx0_.XZDXZ as XZDXZ28_, jbxx0_.YGRY as YGRY28_, jbxx0_.ZC as ZC28_, jbxx0_.ZDZY as ZDZY28_, jbxx0_.ZJH as ZJH28_, jbxx0_.ZJLX as ZJLX28_, jbxx0_.ZRDW as ZRDW28_, jbxx0_.ZSZT as ZSZT28_, jbxx0_.ZUC as ZUC28_, jbxx0_.ZWBH as ZWBH28_, jbxx0_.ZY as ZY28_, jbxx0_.ZYAF as ZYAF28_, jbxx0_.ZYRYXGQK as ZYRYXGQK28_, jbxx0_.ZZMM as ZZMM28_, jbxx0_.ZZQSRQ as ZZQSRQ28_ from JBXX jbxx0_ where 1=1 and (jbxx0_.JSH='9999' or jbxx0_.JSH='0351' or jbxx0_.JSH='0352' or jbxx0_.JSH='0353' or jbxx0_.JSH='0354' or jbxx0_.JSH='0355' or jbxx0_.JSH='0356' or jbxx0_.JSH='0357' or jbxx0_.JSH='0358' or jbxx0_.JSH='0359' or jbxx0_.JSH='0360' or jbxx0_.JSH='0361' or jbxx0_.JSH='0362' or jbxx0_.JSH='0363' or jbxx0_.JSH='0364' or jbxx0_.JSH='0365' or jbxx0_.JSH='0366' or jbxx0_.JSH='0367' or jbxx0_.JSH='0368' or jbxx0_.JSH='0401' or jbxx0_.JSH='0402' or jbxx0_.JSH='0403' or jbxx0_.JSH='0404' or jbxx0_.JSH='0405' or jbxx0_.JSH='0406' or jbxx0_.JSH='0407' or jbxx0_.JSH='0408' or jbxx0_.JSH='0409' or jbxx0_.JSH='0410' or jbxx0_.JSH='0411' or jbxx0_.JSH='0412' or jbxx0_.JSH='0413' or jbxx0_.JSH='0414' or jbxx0_.JSH='0415' or jbxx0_.JSH='0501' or jbxx0_.JSH='0502' or jbxx0_.JSH='0503' or jbxx0_.JSH='0504' or jbxx0_.JSH='0505' or jbxx0_.JSH='0506' or jbxx0_.JSH='0507' or jbxx0_.JSH='0508' or jbxx0_.JSH='0509' or jbxx0_.JSH='0510' or jbxx0_.JSH='0511' or jbxx0_.JSH='0512' or jbxx0_.JSH='0513' or jbxx0_.JSH='0514' or jbxx0_.JSH='0515' or jbxx0_.JSH='0516' or jbxx0_.JSH='0517' or jbxx0_.JSH='0518' or jbxx0_.JSH='0519' or jbxx0_.JSH='0601' or jbxx0_.JSH='0602' or jbxx0_.JSH='0603' or jbxx0_.JSH='0604' or jbxx0_.JSH='0605' or jbxx0_.JSH='0606' or jbxx0_.JSH='0607' or jbxx0_.JSH='0608' or jbxx0_.JSH='0609' or jbxx0_.JSH='0610' or jbxx0_.JSH='0611' or jbxx0_.JSH='0612' or jbxx0_.JSH='0613' or jbxx0_.JSH='0614' or jbxx0_.JSH='0615' or jbxx0_.JSH='0616' or jbxx0_.JSH='0617' or jbxx0_.JSH='0618' or jbxx0_.JSH='0619' or jbxx0_.JSH='0620' or jbxx0_.JSH='0621' or jbxx0_.JSH='0622' or jbxx0_.JSH='0623' or jbxx0_.JSH='0624' or jbxx0_.JSH='0625' or jbxx0_.JSH='0626' or jbxx0_.JSH='0627' or jbxx0_.JSH='0628' or jbxx0_.JSH='0629' or jbxx0_.JSH='0630' or jbxx0_.JSH='0103' or jbxx0_.JSH='0104' or jbxx0_.JSH='0105' or jbxx0_.JSH='0106' or jbxx0_.JSH='0107' or jbxx0_.JSH='0108' or jbxx0_.JSH='0109' or jbxx0_.JSH='0110' or jbxx0_.JSH='0111' or jbxx0_.JSH='0112' or jbxx0_.JSH='0113' or jbxx0_.JSH='0114' or jbxx0_.JSH='0115' or jbxx0_.JSH='0116' or jbxx0_.JSH='0117' or jbxx0_.JSH='0118' or jbxx0_.JSH='0119' or jbxx0_.JSH='0120' or jbxx0_.JSH='0121' or jbxx0_.JSH='0122' or jbxx0_.JSH='0123' or jbxx0_.JSH='0124' or jbxx0_.JSH='0125' or jbxx0_.JSH='0126' or jbxx0_.J SH='0127' or jbxx0_.JSH='0128' or jbxx0_.JSH='0129' or jbxx0_.JSH='0130' or jbxx0_.JSH='0131' or jbxx0_.JSH='0132' or jbxx0_.JSH='0133' or jbxx0_.JSH='0134' or jbxx0_.JSH='0135' or jbxx0_.JSH='0136' or jbxx0_.JSH='0137' or jbxx0_.JSH='0138' or jbxx0_.JSH='0139' or jbxx0_.JSH='0201' or jbxx0_.JSH='0202' or jbxx0_.JSH='0203' or jbxx0_.JSH='0204' or jbxx0_.JSH='0205' or jbxx0_.JSH='0206' or jbxx0_.JSH='0207' or jbxx0_.JSH='0208' or jbxx0_.JSH='0209' or jbxx0_.JSH='0210' or jbxx0_.JSH='0211' or jbxx0_.JSH='0212' or jbxx0_.JSH='0213' or jbxx0_.JSH='0214' or jbxx0_.JSH='0215' or jbxx0_.JSH='0216' or jbxx0_.JSH='0217' or jbxx0_.JSH='0218' or jbxx0_.JSH='0219' or jbxx0_.JSH='0101' or jbxx0_.JSH='0102' or jbxx0_.JSH='0220' or jbxx0_.JSH='0221' or jbxx0_.JSH='0222' or jbxx0_.JSH='0223' or jbxx0_.JSH='0224' or jbxx0_.JSH='0225' or jbxx0_.JSH='0226' or jbxx0_.JSH='0227' or jbxx0_.JSH='0228' or jbxx0_.JSH='0229' or jbxx0_.JSH='0230' or jbxx0_.JSH='0231' or jbxx0_.JSH='0232' or jbxx0_.JSH='0233' or jbxx0_.JSH='0234' or jbxx0_.JSH='0235' or jbxx0_.JSH='0236' or jbxx0_.JSH='0237' or jbxx0_.JSH='0238' or jbxx0_.JSH='0239' or jbxx0_.JSH='0240' or jbxx0_.JSH='0241' or jbxx0_.JSH='0242' or jbxx0_.JSH='0243' or jbxx0_.JSH='0244' or jbxx0_.JSH='0245' or jbxx0_.JSH='0246' or jbxx0_.JSH='0247' or jbxx0_.JSH='0248' or jbxx0_.JSH='0301' or jbxx0_.JSH='0302' or jbxx0_.JSH='0303' or jbxx0_.JSH='0304' or jbxx0_.JSH='0305' or jbxx0_.JSH='0306' or jbxx0_.JSH='0307' or jbxx0_.JSH='0308' or jbxx0_.JSH='0309' or jbxx0_.JSH='0310' or jbxx0_.JSH='0311' or jbxx0_.JSH='0312' or jbxx0_.JSH='0313' or jbxx0_.JSH='0314' or jbxx0_.JSH='0315' or jbxx0_.JSH='0316' or jbxx0_.JSH='0317' or jbxx0_.JSH='0318' or jbxx0_.JSH='0319' or jbxx0_.JSH='0320' or jbxx0_.JSH='0321' or jbxx0_.JSH='0322' or jbxx0_.JSH='0323' or jbxx0_.JSH='0324' or jbxx0_.JSH='0325' or jbxx0_.JSH='0326' or jbxx0_.JSH='0327' or jbxx0_.JSH='0328' or jbxx0_.JSH='0329' or jbxx0_.JSH='0330' or jbxx0_.JSH='0331' or jbxx0_.JSH='0332' or jbxx0_.JSH='0333' or jbxx0_.JSH='0334' or jbxx0_.JSH='0335' or jbxx0_.JSH='0336' or jbxx0_.JSH='0337' or jbxx0_.JSH='0338' or jbxx0_.JSH='0339' or jbxx0_.JSH='0340' or jbxx0_.JSH='0341' or jbxx0_.JSH='0342' or jbxx0_.JSH='0343' or jbxx0_.JSH='0344' or jbxx0_.JSH='0345' or jbxx0_.JSH='0346' or jbxx0_.JSH='0347' or jbxx0_.JSH='0348' or jbxx0_.JSH='0349' or jbxx0_.JSH='0350') and jbxx0_.STATE='R8' and (jbxx0_.JSH like '0206%') and jbxx0_.JSBH='310115111' order by jbxx0_.RSRQ desc ) where rownum <= :1 |
|
47174j02xb70d |
select * from ( select jbxx0_.ID as col_0_0_, (to_xxdmzh('XB', jbxx0_.XB) ) as col_1_0_, (to_xxdmzh('ZJLX', jbxx0_.ZJLX) ) as col_2_0_, (to_xxdmzh('MZ', jbxx0_.MZ) ) as col_3_0_, (to_xxdmzh('HYZK', jbxx0_.HYZK) ) as col_4_0_, (to_xxdmzh('XZQH', jbxx0_.HJD) ) as col_5_0_, (to_xxdmzh('XZQH', jbxx0_.XZD) ) as col_6_0_, (to_xxdmzh('WHCD', jbxx0_.WHCD) ) as col_7_0_, (to_xxdmzh('SF', jbxx0_.SF) ) as col_8_0_, (to_xxdmzh('ZC', jbxx0_.ZC) ) as col_9_0_, (to_xxdmzh('GJ', jbxx0_.GJ) ) as col_10_0_, (to_xxdmzh('XZQH', jbxx0_.JG) ) as col_11_0_, (to_xxdmzh('ZZMM', jbxx0_.ZZMM) ) as col_12_0_, (to_xxdmzh('TSSF', trim(jbxx0_.TSSF)) ) as col_13_0_, (to_xxdmzh('ZY', jbxx0_.ZY) ) as col_14_0_, (to_xxdmzh('JKZK', jbxx0_.JKZK) ) as col_15_0_, (to_xxdmmultizh('AJLB', jbxx0_.AY) ) as col_16_0_, (to_xxdmzh('CYLX', jbxx0_.CYLX) ) as col_17_0_, (to_xxdmzh('BAJD', jbxx0_.BAHJ) ) as col_18_0_, (to_xxdmzh('RSXZ', jbxx0_.RSXZ) ) as col_19_0_, (to_xxdmzh('AJLB', jbxx0_.CAAJ) ) as col_20_0_, (to_xxdmzh('SYPZ', jbxx0_.SYPZ) ) as col_21_0_, (to_xxdmzh('DWLX', jbxx0_.DWLX) ) as col_22_0_, (to_zdzh('AQDJ', jbxx0_.AQDJ) ) as col_23_0_, (to_xxdmzh('CSYY', jbxx0_.CSYY) ) as col_24_0_, (to_xxdmzh('CLJG', jbxx0_.CLJG) ) as col_25_0_, (to_xxdmzh('FJX', jbxx0_.FJX) ) as col_26_0_, jbxx0_.ID as ID28_, jbxx0_.AQDJ as AQDJ28_, jbxx0_.AY as AY28_, jbxx0_.AZB as AZB28_, jbxx0_.BADW as BADW28_, jbxx0_.BAHJ as BAHJ28_, jbxx0_.BAR as BAR28_, jbxx0_.BARJH as BARJH28_, jbxx0_.BHLX as BHLX28 _, jbxx0_.BM as BM28_, jbxx0_.BMTY as BMTY28_, jbxx0_.BZ as BZ28_, jbxx0_.CAAJ as CAAJ28_, jbxx0_.CLJG as CLJG28_, jbxx0_.CREATETIME as CREATETIME28_, jbxx0_.CSQX as CSQX28_, jbxx0_.CSRQ as CSRQ28_, jbxx0_.CSSJ as CSSJ28_, jbxx0_.CSYY as CSYY28_, jbxx0_.CYLX as CYLX28_, jbxx0_.DAH as DAH28_, jbxx0_.DBRQ as DBRQ28_, jbxx0_.DH as DH28_, jbxx0_.DWLX as DWLX28_, jbxx0_.EMLX as EMLX28_, jbxx0_.FJX as FJX28_, jbxx0_.FZJL as FZJL28_, jbxx0_.GCBH as GCBH28_, jbxx0_.GJ as GJ28_, jbxx0_.GRJL as GRJL28_, jbxx0_.GYQX as GYQX28_, jbxx0_.GZDW as GZDW28_, jbxx0_.HJD as HJD28_, jbxx0_.HJDXZ as HJDXZ28_, jbxx0_.HX as HX28_, jbxx0_.HXQX as HXQX28_, jbxx0_.HYZK as HYZK28_, jbxx0_.JB as JB28_, jbxx0_.JG as JG28_, jbxx0_.JJ as JJ28_, jbxx0_.JKZK as JKZK28_, jbxx0_.JLRQ as JLRQ28_, jbxx0_.JSBH as JSBH28_, jbxx0_.JSH as JSH28_, jbxx0_.JSHJ as JSHJ28_, jbxx0_.JSLX as JSLX28_, jbxx0_.JSLY as JSLY28_, jbxx0_.JYAQ as JYAQ28_, jbxx0_.JYRQ as JYRQ28_, jbxx0_.LDF as LDF28_, jbxx0_.LSCSYY as LSCSYY28_, jbxx0_.LSFH as LSFH28_, jbxx0_.MZ as MZ28_, jbxx0_.OPERATOR as OPERATOR28_, jbxx0_.PWH as PWH28_, jbxx0_.RSRQ as RSRQ28_, jbxx0_.RSXZ as RSXZ28_, jbxx0_.RYBH as RYBH28_, jbxx0_.RYGLLB as RYGLLB28_, jbxx0_.SAVETIME as SAVETIME28_, jbxx0_.SCBZ as SCBZ28_, jbxx0_.SF as SF28_, jbxx0_.SG as SG28_, jbxx0_.SNBH as SNBH28_, jbxx0_.STATE as STATE28_, jbxx0_.SY as SY28_, jbxx0_.SYDW as SYDW28_, jbxx0_.SYPZ as SYPZ28_, jbxx0_.SYPZWSH as SYPZWSH28_, jbxx0_.SYR as SYR28_, jbxx0_.TSBJ as TSBJ28_, jbxx0_.TSSF as TSSF28_, jbxx0_.WBRYBH as WBRYBH28_, jbxx0_.WHCD as WHCD28_, jbxx0_.WXDJ as WXDJ28_, jbxx0_.XB as XB28_, jbxx0_.XM as XM28_, jbxx0_.XMPY as XMPY28_, jbxx0_.XQ as XQ28_, jbxx0_.XZD as XZD28_, jbxx0_.XZDXZ as XZDXZ28_, jbxx0_.YGRY as YGRY28_, jbxx0_.ZC as ZC28_, jbxx0_.ZDZY as ZDZY28_, jbxx0_.ZJH as ZJH28_, jbxx0_.ZJLX as ZJLX28_, jbxx0_.ZRDW as ZRDW28_, jbxx0_.ZSZT as ZSZT28_, jbxx0_.ZUC as ZUC28_, jbxx0_.ZWBH as ZWBH28_, jbxx0_.ZY as ZY28_, jbxx0_.ZYAF as ZYAF28_, jbxx0_.ZYRYXGQK as ZYRYXGQK28_, jbxx0_.ZZMM as ZZMM28_, jbxx0_.ZZQSRQ as ZZQSRQ28_ from JBXX jbxx0_ where 1=1 and (jbxx0_.JSH='9999' or jbxx0_.JSH='0101' or jbxx0_.JSH='0102' or jbxx0_.JSH='0103' or jbxx0_.JSH='0104' or jbxx0_.JSH='0105' or jbxx0_.JSH='0106' or jbxx0_.JSH='0107' or jbxx0_.JSH='0108' or jbxx0_.JSH='0109' or jbxx0_.JSH='0110' or jbxx0_.JSH='0111' or jbxx0_.JSH='0112' or jbxx0_.JSH='0113' or jbxx0_.JSH='0114' or jbxx0_.JSH='0115' or jbxx0_.JSH='0116' or jbxx0_.JSH='0201' or jbxx0_.JSH='0202' or jbxx0_.JSH='0203' or jbxx0_.JSH='0204' or jbxx0_.JSH='0205' or jbxx0_.JSH='0206' or jbxx0_.JSH='0207' or jbxx0_.JSH='0208' or jbxx0_.JSH='0209' or jbxx0_.JSH='0210' or jbxx0_.JSH='0211' or jbxx0_.JSH='0212' or jbxx0_.JSH='0213' or jbxx0_.JSH='0214' or jbxx0_.JSH='0215' or jbxx0_.JSH='0216' or jbxx0_.JSH='0217' or jbxx0_.JSH='0218' or jbxx0_.JSH='0219' or jbxx0_.JSH='0301' or jbxx0_.JSH='0302' or jbxx0_.JSH='0303' or jbxx0_.JSH='0304' or jbxx0_.JSH='0305' or jbxx0_.JSH='0306' or jbxx0_.JSH='0307' or jbxx0_.JSH='0308' or jbxx0_.JSH='0309' or jbxx0_.JSH='0310' or jbxx0_.JSH='0311' or jbxx0_.JSH='0312' or jbxx0_.JSH='0313' or jbxx0_.JSH='0314' or jbxx0_.JSH='0315' or jbxx0_.JSH='0316' or jbxx0_.JSH='0317' or jbxx0_.JSH='0318' or jbxx0_.JSH='0319' or jbxx0_.JSH='0401' or jbxx0_.JSH='0402' or jbxx0_.JSH='0403' or jbxx0_.JSH='0404' or jbxx0_.JSH='0405' or jbxx0_.JSH='0406' or jbxx0_.JSH='0407' or jbxx0_.JSH='0408' or jbxx0_.JSH='0409' or jbxx0_.JSH='0410' or jbxx0_.JSH='0411' or jbxx0_.JSH='0412' or jbxx0_.JSH='0413' or jbxx0_.JSH='0414' or jbxx0_.JSH='0415' or jbxx0_.JSH='0416' or jbxx0_.JSH='0501' or jbxx0_.JSH='0502' or jbxx0_.JSH='0503' or jbxx0_.JSH='0504' or jbxx0_.JSH='0505' or jbxx0_.JSH='0506' or jbxx0_.JSH='0507' or jbxx0_.JSH='0508' or jbxx0_.JSH='0509' or jbxx0_.JSH='0510') and jbxx0_.STATE='R7' and jbxx0_.JSBH='310101111' order by jbxx0_.RSRQ desc ) where rownum <= :1 |
|
5573mfyrgg583 |
select * from ( select jbxx0_.ID as col_0_0_, (to_xxdmzh('XB', jbxx0_.XB) ) as col_1_0_, (to_xxdmzh('ZJLX', jbxx0_.ZJLX) ) as col_2_0_, (to_xxdmzh('MZ', jbxx0_.MZ) ) as col_3_0_, (to_xxdmzh('HYZK', jbxx0_.HYZK) ) as col_4_0_, (to_xxdmzh('XZQH', jbxx0_.HJD) ) as col_5_0_, (to_xxdmzh('XZQH', jbxx0_.XZD) ) as col_6_0_, (to_xxdmzh('WHCD', jbxx0_.WHCD) ) as col_7_0_, (to_xxdmzh('SF', jbxx0_.SF) ) as col_8_0_, (to_xxdmzh('ZC', jbxx0_.ZC) ) as col_9_0_, (to_xxdmzh('GJ', jbxx0_.GJ) ) as col_10_0_, (to_xxdmzh('XZQH', jbxx0_.JG) ) as col_11_0_, (to_xxdmzh('ZZMM', jbxx0_.ZZMM) ) as col_12_0_, (to_xxdmzh('TSSF', trim(jbxx0_.TSSF)) ) as col_13_0_, (to_xxdmzh('ZY', jbxx0_.ZY) ) as col_14_0_, (to_xxdmzh('JKZK', jbxx0_.JKZK) ) as col_15_0_, (to_xxdmmultizh('AJLB', jbxx0_.AY) ) as col_16_0_, (to_xxdmzh('CYLX', jbxx0_.CYLX) ) as col_17_0_, (to_xxdmzh('BAJD', jbxx0_.BAHJ) ) as col_18_0_, (to_xxdmzh('RSXZ', jbxx0_.RSXZ) ) as col_19_0_, (to_xxdmzh('AJLB', jbxx0_.CAAJ) ) as col_20_0_, (to_xxdmzh('SYPZ', jbxx0_.SYPZ) ) as col_21_0_, (to_xxdmzh('DWLX', jbxx0_.DWLX) ) as col_22_0_, (to_zdzh('AQDJ', jbxx0_.AQDJ) ) as col_23_0_, (to_xxdmzh('CSYY', jbxx0_.CSYY) ) as col_24_0_, (to_xxdmzh('CLJG', jbxx0_.CLJG) ) as col_25_0_, (to_xxdmzh('FJX', jbxx0_.FJX) ) as col_26_0_, jbxx0_.ID as ID28_, jbxx0_.AQDJ as AQDJ28_, jbxx0_.AY as AY28_, jbxx0_.AZB as AZB28_, jbxx0_.BADW as BADW28_, jbxx0_.BAHJ as BAHJ28_, jbxx0_.BAR as BAR28_, jbxx0_.BARJH as BARJH28_, jbxx0_.BHLX as BHLX28 _, jbxx0_.BM as BM28_, jbxx0_.BMTY as BMTY28_, jbxx0_.BZ as BZ28_, jbxx0_.CAAJ as CAAJ28_, jbxx0_.CLJG as CLJG28_, jbxx0_.CREATETIME as CREATETIME28_, jbxx0_.CSQX as CSQX28_, jbxx0_.CSRQ as CSRQ28_, jbxx0_.CSSJ as CSSJ28_, jbxx0_.CSYY as CSYY28_, jbxx0_.CYLX as CYLX28_, jbxx0_.DAH as DAH28_, jbxx0_.DBRQ as DBRQ28_, jbxx0_.DH as DH28_, jbxx0_.DWLX as DWLX28_, jbxx0_.EMLX as EMLX28_, jbxx0_.FJX as FJX28_, jbxx0_.FZJL as FZJL28_, jbxx0_.GCBH as GCBH28_, jbxx0_.GJ as GJ28_, jbxx0_.GRJL as GRJL28_, jbxx0_.GYQX as GYQX28_, jbxx0_.GZDW as GZDW28_, jbxx0_.HJD as HJD28_, jbxx0_.HJDXZ as HJDXZ28_, jbxx0_.HX as HX28_, jbxx0_.HXQX as HXQX28_, jbxx0_.HYZK as HYZK28_, jbxx0_.JB as JB28_, jbxx0_.JG as JG28_, jbxx0_.JJ as JJ28_, jbxx0_.JKZK as JKZK28_, jbxx0_.JLRQ as JLRQ28_, jbxx0_.JSBH as JSBH28_, jbxx0_.JSH as JSH28_, jbxx0_.JSHJ as JSHJ28_, jbxx0_.JSLX as JSLX28_, jbxx0_.JSLY as JSLY28_, jbxx0_.JYAQ as JYAQ28_, jbxx0_.JYRQ as JYRQ28_, jbxx0_.LDF as LDF28_, jbxx0_.LSCSYY as LSCSYY28_, jbxx0_.LSFH as LSFH28_, jbxx0_.MZ as MZ28_, jbxx0_.OPERATOR as OPERATOR28_, jbxx0_.PWH as PWH28_, jbxx0_.RSRQ as RSRQ28_, jbxx0_.RSXZ as RSXZ28_, jbxx0_.RYBH as RYBH28_, jbxx0_.RYGLLB as RYGLLB28_, jbxx0_.SAVETIME as SAVETIME28_, jbxx0_.SCBZ as SCBZ28_, jbxx0_.SF as SF28_, jbxx0_.SG as SG28_, jbxx0_.SNBH as SNBH28_, jbxx0_.STATE as STATE28_, jbxx0_.SY as SY28_, jbxx0_.SYDW as SYDW28_, jbxx0_.SYPZ as SYPZ28_, jbxx0_.SYPZWSH as SYPZWSH28_, jbxx0_.SYR as SYR28_, jbxx0_.TSBJ as TSBJ28_, jbxx0_.TSSF as TSSF28_, jbxx0_.WBRYBH as WBRYBH28_, jbxx0_.WHCD as WHCD28_, jbxx0_.WXDJ as WXDJ28_, jbxx0_.XB as XB28_, jbxx0_.XM as XM28_, jbxx0_.XMPY as XMPY28_, jbxx0_.XQ as XQ28_, jbxx0_.XZD as XZD28_, jbxx0_.XZDXZ as XZDXZ28_, jbxx0_.YGRY as YGRY28_, jbxx0_.ZC as ZC28_, jbxx0_.ZDZY as ZDZY28_, jbxx0_.ZJH as ZJH28_, jbxx0_.ZJLX as ZJLX28_, jbxx0_.ZRDW as ZRDW28_, jbxx0_.ZSZT as ZSZT28_, jbxx0_.ZUC as ZUC28_, jbxx0_.ZWBH as ZWBH28_, jbxx0_.ZY as ZY28_, jbxx0_.ZYAF as ZYAF28_, jbxx0_.ZYRYXGQK as ZYRYXGQK28_, jbxx0_.ZZMM as ZZMM28_, jbxx0_.ZZQSRQ as ZZQSRQ28_ from JBXX jbxx0_ where 1=1 and (jbxx0_.JSH='9999' or jbxx0_.JSH='0351' or jbxx0_.JSH='0352' or jbxx0_.JSH='0353' or jbxx0_.JSH='0354' or jbxx0_.JSH='0355' or jbxx0_.JSH='0356' or jbxx0_.JSH='0357' or jbxx0_.JSH='0358' or jbxx0_.JSH='0359' or jbxx0_.JSH='0360' or jbxx0_.JSH='0361' or jbxx0_.JSH='0362' or jbxx0_.JSH='0363' or jbxx0_.JSH='0364' or jbxx0_.JSH='0365' or jbxx0_.JSH='0366' or jbxx0_.JSH='0367' or jbxx0_.JSH='0368' or jbxx0_.JSH='0401' or jbxx0_.JSH='0402' or jbxx0_.JSH='0403' or jbxx0_.JSH='0404' or jbxx0_.JSH='0405' or jbxx0_.JSH='0406' or jbxx0_.JSH='0407' or jbxx0_.JSH='0408' or jbxx0_.JSH='0409' or jbxx0_.JSH='0410' or jbxx0_.JSH='0411' or jbxx0_.JSH='0412' or jbxx0_.JSH='0413' or jbxx0_.JSH='0414' or jbxx0_.JSH='0415' or jbxx0_.JSH='0501' or jbxx0_.JSH='0502' or jbxx0_.JSH='0503' or jbxx0_.JSH='0504' or jbxx0_.JSH='0505' or jbxx0_.JSH='0506' or jbxx0_.JSH='0507' or jbxx0_.JSH='0508' or jbxx0_.JSH='0509' or jbxx0_.JSH='0510' or jbxx0_.JSH='0511' or jbxx0_.JSH='0512' or jbxx0_.JSH='0513' or jbxx0_.JSH='0514' or jbxx0_.JSH='0515' or jbxx0_.JSH='0516' or jbxx0_.JSH='0517' or jbxx0_.JSH='0518' or jbxx0_.JSH='0519' or jbxx0_.JSH='0601' or jbxx0_.JSH='0602' or jbxx0_.JSH='0603' or jbxx0_.JSH='0604' or jbxx0_.JSH='0605' or jbxx0_.JSH='0606' or jbxx0_.JSH='0607' or jbxx0_.JSH='0608' or jbxx0_.JSH='0609' or jbxx0_.JSH='0610' or jbxx0_.JSH='0611' or jbxx0_.JSH='0612' or jbxx0_.JSH='0613' or jbxx0_.JSH='0614' or jbxx0_.JSH='0615' or jbxx0_.JSH='0616' or jbxx0_.JSH='0617' or jbxx0_.JSH='0618' or jbxx0_.JSH='0619' or jbxx0_.JSH='0620' or jbxx0_.JSH='0621' or jbxx0_.JSH='0622' or jbxx0_.JSH='0623' or jbxx0_.JSH='0624' or jbxx0_.JSH='0625' or jbxx0_.JSH='0626' or jbxx0_.JSH='0627' or jbxx0_.JSH='0628' or jbxx0_.JSH='0629' or jbxx0_.JSH='0630' or jbxx0_.JSH='0103' or jbxx0_.JSH='0104' or jbxx0_.JSH='0105' or jbxx0_.JSH='0106' or jbxx0_.JSH='0107' or jbxx0_.JSH='0108' or jbxx0_.JSH='0109' or jbxx0_.JSH='0110' or jbxx0_.JSH='0111' or jbxx0_.JSH='0112' or jbxx0_.JSH='0113' or jbxx0_.JSH='0114' or jbxx0_.JSH='0115' or jbxx0_.JSH='0116' or jbxx0_.JSH='0117' or jbxx0_.JSH='0118' or jbxx0_.JSH='0119' or jbxx0_.JSH='0120' or jbxx0_.JSH='0121' or jbxx0_.JSH='0122' or jbxx0_.JSH='0123' or jbxx0_.JSH='0124' or jbxx0_.JSH='0125' or jbxx0_.JSH='0126' or jbxx0_.JSH='0127' or jbxx0_.JSH='0128' or jbxx0_.JSH='0129' or jbxx0_.JSH='0130' or jbxx0_.JS H='0131' or jbxx0_.JSH='0132' or jbxx0_.JSH='0133' or jbxx0_.JSH='0134' or jbxx0_.JSH='0135' or jbxx0_.JSH='0136' or jbxx0_.JSH='0137' or jbxx0_.JSH='0138' or jbxx0_.JSH='0139' or jbxx0_.JSH='0201' or jbxx0_.JSH='0202' or jbxx0_.JSH='0203' or jbxx0_.JSH='0204' or jbxx0_.JSH='0205' or jbxx0_.JSH='0206' or jbxx0_.JSH='0207' or jbxx0_.JSH='0208' or jbxx0_.JSH='0209' or jbxx0_.JSH='0210' or jbxx0_.JSH='0211' or jbxx0_.JSH='0212' or jbxx0_.JSH='0213' or jbxx0_.JSH='0214' or jbxx0_.JSH='0215' or jbxx0_.JSH='0216' or jbxx0_.JSH='0217' or jbxx0_.JSH='0218' or jbxx0_.JSH='0219' or jbxx0_.JSH='0101' or jbxx0_.JSH='0102' or jbxx0_.JSH='0220' or jbxx0_.JSH='0221' or jbxx0_.JSH='0222' or jbxx0_.JSH='0223' or jbxx0_.JSH='0224' or jbxx0_.JSH='0225' or jbxx0_.JSH='0226' or jbxx0_.JSH='0227' or jbxx0_.JSH='0228' or jbxx0_.JSH='0229' or jbxx0_.JSH='0230' or jbxx0_.JSH='0231' or jbxx0_.JSH='0232' or jbxx0_.JSH='0233' or jbxx0_.JSH='0234' or jbxx0_.JSH='0235' or jbxx0_.JSH='0236' or jbxx0_.JSH='0237' or jbxx0_.JSH='0238' or jbxx0_.JSH='0239' or jbxx0_.JSH='0240' or jbxx0_.JSH='0241' or jbxx0_.JSH='0242' or jbxx0_.JSH='0243' or jbxx0_.JSH='0244' or jbxx0_.JSH='0245' or jbxx0_.JSH='0246' or jbxx0_.JSH='0247' or jbxx0_.JSH='0248' or jbxx0_.JSH='0301' or jbxx0_.JSH='0302' or jbxx0_.JSH='0303' or jbxx0_.JSH='0304' or jbxx0_.JSH='0305' or jbxx0_.JSH='0306' or jbxx0_.JSH='0307' or jbxx0_.JSH='0308' or jbxx0_.JSH='0309' or jbxx0_.JSH='0310' or jbxx0_.JSH='0311' or jbxx0_.JSH='0312' or jbxx0_.JSH='0313' or jbxx0_.JSH='0314' or jbxx0_.JSH='0315' or jbxx0_.JSH='0316' or jbxx0_.JSH='0317' or jbxx0_.JSH='0318' or jbxx0_.JSH='0319' or jbxx0_.JSH='0320' or jbxx0_.JSH='0321' or jbxx0_.JSH='0322' or jbxx0_.JSH='0323' or jbxx0_.JSH='0324' or jbxx0_.JSH='0325' or jbxx0_.JSH='0326' or jbxx0_.JSH='0327' or jbxx0_.JSH='0328' or jbxx0_.JSH='0329' or jbxx0_.JSH='0330' or jbxx0_.JSH='0331' or jbxx0_.JSH='0332' or jbxx0_.JSH='0333' or jbxx0_.JSH='0334' or jbxx0_.JSH='0335' or jbxx0_.JSH='0336' or jbxx0_.JSH='0337' or jbxx0_.JSH='0338' or jbxx0_.JSH='0339' or jbxx0_.JSH='0340' or jbxx0_.JSH='0341' or jbxx0_.JSH='0342' or jbxx0_.JSH='0343' or jbxx0_.JSH='0344' or jbxx0_.JSH='0345' or jbxx0_.JSH='0346' or jbxx0_.JSH='0347' or jbxx0_.JSH='0348' or jbxx0_.JSH='0349' or jbxx0_.JSH='0350') and jbxx0_.STATE='R8' and jbxx0_.JSBH='310115111' order by jbxx0_.RSRQ desc ) where rownum <= :1 |
|
cxv4s81pts1q9 |
SELECT CONTENT FROM XXDM X WHERE X.FIELDNAME=:B2 AND X.CODE=TRIM(:B1 ) AND ROWNUM=1 |
|
f2yzzhdjsgzfp |
select * from ( select jbxx0_.ID as col_0_0_, (to_xxdmzh('XB', jbxx0_.XB) ) as col_1_0_, (to_xxdmzh('ZJLX', jbxx0_.ZJLX) ) as col_2_0_, (to_xxdmzh('MZ', jbxx0_.MZ) ) as col_3_0_, (to_xxdmzh('HYZK', jbxx0_.HYZK) ) as col_4_0_, (to_xxdmzh('XZQH', jbxx0_.HJD) ) as col_5_0_, (to_xxdmzh('XZQH', jbxx0_.XZD) ) as col_6_0_, (to_xxdmzh('WHCD', jbxx0_.WHCD) ) as col_7_0_, (to_xxdmzh('SF', jbxx0_.SF) ) as col_8_0_, (to_xxdmzh('ZC', jbxx0_.ZC) ) as col_9_0_, (to_xxdmzh('GJ', jbxx0_.GJ) ) as col_10_0_, (to_xxdmzh('XZQH', jbxx0_.JG) ) as col_11_0_, (to_xxdmzh('ZZMM', jbxx0_.ZZMM) ) as col_12_0_, (to_xxdmzh('TSSF', trim(jbxx0_.TSSF)) ) as col_13_0_, (to_xxdmzh('ZY', jbxx0_.ZY) ) as col_14_0_, (to_xxdmzh('JKZK', jbxx0_.JKZK) ) as col_15_0_, (to_xxdmmultizh('AJLB', jbxx0_.AY) ) as col_16_0_, (to_xxdmzh('CYLX', jbxx0_.CYLX) ) as col_17_0_, (to_xxdmzh('BAJD', jbxx0_.BAHJ) ) as col_18_0_, (to_xxdmzh('RSXZ', jbxx0_.RSXZ) ) as col_19_0_, (to_xxdmzh('AJLB', jbxx0_.CAAJ) ) as col_20_0_, (to_xxdmzh('SYPZ', jbxx0_.SYPZ) ) as col_21_0_, (to_xxdmzh('DWLX', jbxx0_.DWLX) ) as col_22_0_, (to_zdzh('AQDJ', jbxx0_.AQDJ) ) as col_23_0_, (to_xxdmzh('CSYY', jbxx0_.CSYY) ) as col_24_0_, (to_xxdmzh('CLJG', jbxx0_.CLJG) ) as col_25_0_, (to_xxdmzh('FJX', jbxx0_.FJX) ) as col_26_0_, jbxx0_.ID as ID28_, jbxx0_.AQDJ as AQDJ28_, jbxx0_.AY as AY28_, jbxx0_.AZB as AZB28_, jbxx0_.BADW as BADW28_, jbxx0_.BAHJ as BAHJ28_, jbxx0_.BAR as BAR28_, jbxx0_.BARJH as BARJH28_, jbxx0_.BHLX as BHLX28 _, jbxx0_.BM as BM28_, jbxx0_.BMTY as BMTY28_, jbxx0_.BZ as BZ28_, jbxx0_.CAAJ as CAAJ28_, jbxx0_.CLJG as CLJG28_, jbxx0_.CREATETIME as CREATETIME28_, jbxx0_.CSQX as CSQX28_, jbxx0_.CSRQ as CSRQ28_, jbxx0_.CSSJ as CSSJ28_, jbxx0_.CSYY as CSYY28_, jbxx0_.CYLX as CYLX28_, jbxx0_.DAH as DAH28_, jbxx0_.DBRQ as DBRQ28_, jbxx0_.DH as DH28_, jbxx0_.DWLX as DWLX28_, jbxx0_.EMLX as EMLX28_, jbxx0_.FJX as FJX28_, jbxx0_.FZJL as FZJL28_, jbxx0_.GCBH as GCBH28_, jbxx0_.GJ as GJ28_, jbxx0_.GRJL as GRJL28_, jbxx0_.GYQX as GYQX28_, jbxx0_.GZDW as GZDW28_, jbxx0_.HJD as HJD28_, jbxx0_.HJDXZ as HJDXZ28_, jbxx0_.HX as HX28_, jbxx0_.HXQX as HXQX28_, jbxx0_.HYZK as HYZK28_, jbxx0_.JB as JB28_, jbxx0_.JG as JG28_, jbxx0_.JJ as JJ28_, jbxx0_.JKZK as JKZK28_, jbxx0_.JLRQ as JLRQ28_, jbxx0_.JSBH as JSBH28_, jbxx0_.JSH as JSH28_, jbxx0_.JSHJ as JSHJ28_, jbxx0_.JSLX as JSLX28_, jbxx0_.JSLY as JSLY28_, jbxx0_.JYAQ as JYAQ28_, jbxx0_.JYRQ as JYRQ28_, jbxx0_.LDF as LDF28_, jbxx0_.LSCSYY as LSCSYY28_, jbxx0_.LSFH as LSFH28_, jbxx0_.MZ as MZ28_, jbxx0_.OPERATOR as OPERATOR28_, jbxx0_.PWH as PWH28_, jbxx0_.RSRQ as RSRQ28_, jbxx0_.RSXZ as RSXZ28_, jbxx0_.RYBH as RYBH28_, jbxx0_.RYGLLB as RYGLLB28_, jbxx0_.SAVETIME as SAVETIME28_, jbxx0_.SCBZ as SCBZ28_, jbxx0_.SF as SF28_, jbxx0_.SG as SG28_, jbxx0_.SNBH as SNBH28_, jbxx0_.STATE as STATE28_, jbxx0_.SY as SY28_, jbxx0_.SYDW as SYDW28_, jbxx0_.SYPZ as SYPZ28_, jbxx0_.SYPZWSH as SYPZWSH28_, jbxx0_.SYR as SYR28_, jbxx0_.TSBJ as TSBJ28_, jbxx0_.TSSF as TSSF28_, jbxx0_.WBRYBH as WBRYBH28_, jbxx0_.WHCD as WHCD28_, jbxx0_.WXDJ as WXDJ28_, jbxx0_.XB as XB28_, jbxx0_.XM as XM28_, jbxx0_.XMPY as XMPY28_, jbxx0_.XQ as XQ28_, jbxx0_.XZD as XZD28_, jbxx0_.XZDXZ as XZDXZ28_, jbxx0_.YGRY as YGRY28_, jbxx0_.ZC as ZC28_, jbxx0_.ZDZY as ZDZY28_, jbxx0_.ZJH as ZJH28_, jbxx0_.ZJLX as ZJLX28_, jbxx0_.ZRDW as ZRDW28_, jbxx0_.ZSZT as ZSZT28_, jbxx0_.ZUC as ZUC28_, jbxx0_.ZWBH as ZWBH28_, jbxx0_.ZY as ZY28_, jbxx0_.ZYAF as ZYAF28_, jbxx0_.ZYRYXGQK as ZYRYXGQK28_, jbxx0_.ZZMM as ZZMM28_, jbxx0_.ZZQSRQ as ZZQSRQ28_ from JBXX jbxx0_ where 1=1 and (jbxx0_.JSH='9999' or jbxx0_.JSH='0103' or jbxx0_.JSH='0104' or jbxx0_.JSH='0105' or jbxx0_.JSH='0106' or jbxx0_.JSH='0107' or jbxx0_.JSH='0108' or jbxx0_.JSH='0109' or jbxx0_.JSH='0110' or jbxx0_.JSH='0111' or jbxx0_.JSH='0112' or jbxx0_.JSH='0113' or jbxx0_.JSH='0114' or jbxx0_.JSH='0115' or jbxx0_.JSH='0116' or jbxx0_.JSH='0117' or jbxx0_.JSH='0118' or jbxx0_.JSH='0119' or jbxx0_.JSH='0120' or jbxx0_.JSH='0121' or jbxx0_.JSH='0122' or jbxx0_.JSH='0123' or jbxx0_.JSH='0124' or jbxx0_.JSH='0125' or jbxx0_.JSH='0126' or jbxx0_.JSH='0127' or jbxx0_.JSH='0128' or jbxx0_.JSH='0129' or jbxx0_.JSH='0201' or jbxx0_.JSH='0202' or jbxx0_.JSH='0203' or jbxx0_.JSH='0204' or jbxx0_.JSH='0205' or jbxx0_.JSH='0206' or jbxx0_.JSH='0207' or jbxx0_.JSH='0208' or jbxx0_.JSH='0209' or jbxx0_.JSH='0210' or jbxx0_.JSH='0211' or jbxx0_.JSH='0212' or jbxx0_.JSH='0213' or jbxx0_.JSH='0214' or jbxx0_.JSH='0215' or jbxx0_.JSH='0216' or jbxx0_.JSH='0217' or jbxx0_.JSH='0218' or jbxx0_.JSH='0219' or jbxx0_.JSH='0220' or jbxx0_.JSH='0221' or jbxx0_.JSH='0222' or jbxx0_.JSH='0223' or jbxx0_.JSH='0224' or jbxx0_.JSH='0225' or jbxx0_.JSH='0226' or jbxx0_.JSH='0227' or jbxx0_.JSH='0228' or jbxx0_.JSH='0229' or jbxx0_.JSH='0101' or jbxx0_.JSH='0102') and jbxx0_.STATE='R8' and jbxx0_.JSBH='310000113' order by jbxx0_.RSRQ desc ) where rownum <= :1 |
