PLSQL外键悲剧
摘要：SELECT DISTINCT GE.APPLY_TYPE_ID,P.*, GE.ENDO_ID GEN_ENDO_ID, S.STATUS_NAME, R.BIZ_PRDT_CODE, TO_CHAR(GE.EFF_DATE, 'dd/mm/yyyy') ENDO_EFF_DATE, GE.CREATOR_ID ENDO_CREAOR FROM T_POLICY_GENERAL_LOG P, T_GEN_POLICY_STATUS S, T_PRODUCT_GENERAL R, T_GEDO_ENDORSEMENT GEWHERE S.STATUS_ID = P.STATUS_ID AN
阅读全文
posted @
2011-01-12 20:43
烂人
阅读(1365)
推荐(0) 编辑
