insert into BM_TYZD00 (NBBH00, ZDMC00, LBBZ00, BH0000, MC0000, PYSM00, WBSM00, XSXH00, BZ0000, YXBZ00, XTBZ00, WHBZ00, DJ0000, MKDM00, BZDYBH, BH0001, MC0001, BH0002, CJRQSJ, XGRQSJ, CJR000, XGR000, ZDPYSM, ZDWBSM) select SQ_BM_TYZD00_NBBH00.nextval,'住院摆药过滤条件', '0', '23', '贮藏方法', 'zcff', 'mayi', 16.00, '', '1', '0', '1', 0.00, null, null, null, null, null, null, null, null, null, 'zcff', 'mayi' from dual where not exists( select 1 from BM_TYZD00 where ZDMC00='住院摆药过滤条件' and BH0000='16'); commit;