从数据库中查询规则

1、查询C_BIZ表

select * from c_biz;

2、查询规则信息

SELECT DISTINCT c.rule_name, c.RULE_DESC,  c.RULE_SAMPLE, c.RULE_BAD_SAMPLE
  FROM CM_BIZ_SRC_MAP X, CM_SRC A, CP_SRC_DETAIL B, CP_RULE C, CM_CODE_INFO D, CP_SRC_DETAIL_FILTER E
 WHERE A.SRC_ID = B.SRC_ID
   AND B.RULE_ID = C.RULE_ID
   AND B.RULE_PRIORITY = D.CODE
   AND D.CODE_CATEGORY = 507
   AND X.SRC_ID = A.SRC_ID
   AND A.CHANGE_REASON_CODE < 9000
   AND X.BIZ_ID = 3
   AND B.SRC_ID = E.SRC_ID(+)
   AND B.RULE_ID = E.RULE_ID(+)
   AND B.LINE_NUMBER = E.LINE_NUMBER(+)

查询某个规则集的规则信息，可以在上面SQL中X.BIZ_ID=(?)进行替换即可。?值来自于C_BIZ表中的BIZ_ID.