源生的sql语句
select(select JG.SWJG_DM || JG.MC_J from DB_XTWH.T_DM_GY_SWJG JG
where JG.SWJG_DM = r.glJG_DM),
R.NSRBM,
R.NSR_MC,
(SELECT R.ZGY || RY.MC
FROM DB_XTWH.T_DM_GY_SWRY RY
WHERE RY.SWRY_DM = R.ZGY),
R.LXDH_DH,
R.SJJY_DZ,
(SELECT FK.FPZL_DM || ZL.MC_J
FROM DB_XTWH.T_DM_FP_FPZL ZL
WHERE ZL.FPZL_DM = FK.FPZL_DM),
FK.FPPC,
FK.FP_QSHM,
FK.FP_ZZHM,
substr(fk.fp_zzhm, 2, 7) - substr(fk.fp_qshm, 2, 7) + 1 ,
TO_CHAR(FK.LR_SJ, 'yyyy-mm-dd')
FROM db_djgl.T_DJ_JGNSR R, DB_FPGL.T_FP_NSRFPKC FK , db_xtwh.t_dm_fp_fpzl fpzl
WHERE R.GLJG_DM like '2440608%'
AND R.DJ_ZT <> '50'
AND FK.NSRNBM = R.NSRNBM and fk.fpzl_dm=fpzl.fpzl_dm; 现在在用hibernate做开发,数据库是调用别人的数据库,如果不用hibernate的话有什么好建议.
希望各位大大能给点意见.
select(select JG.SWJG_DM || JG.MC_J from DB_XTWH.T_DM_GY_SWJG JG
where JG.SWJG_DM = r.glJG_DM),
R.NSRBM,
R.NSR_MC,
(SELECT R.ZGY || RY.MC
FROM DB_XTWH.T_DM_GY_SWRY RY
WHERE RY.SWRY_DM = R.ZGY),
R.LXDH_DH,
R.SJJY_DZ,
(SELECT FK.FPZL_DM || ZL.MC_J
FROM DB_XTWH.T_DM_FP_FPZL ZL
WHERE ZL.FPZL_DM = FK.FPZL_DM),
FK.FPPC,
FK.FP_QSHM,
FK.FP_ZZHM,
substr(fk.fp_zzhm, 2, 7) - substr(fk.fp_qshm, 2, 7) + 1 ,
TO_CHAR(FK.LR_SJ, 'yyyy-mm-dd')
FROM db_djgl.T_DJ_JGNSR R, DB_FPGL.T_FP_NSRFPKC FK , db_xtwh.t_dm_fp_fpzl fpzl
WHERE R.GLJG_DM like '2440608%'
AND R.DJ_ZT <> '50'
AND FK.NSRNBM = R.NSRNBM and fk.fpzl_dm=fpzl.fpzl_dm; 现在在用hibernate做开发,数据库是调用别人的数据库,如果不用hibernate的话有什么好建议.
希望各位大大能给点意见.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货