MERGE INTO db_blacklist t
USING (
SELECT 。。。 FROM DUAL UNION ALL
SELECT 。。。 FROM DUAL UNION ALL
。。。
) s
ON (t.dbid = s.dbid AND t.is_active = ‘Y’)
WHEN NOT MATCHED THEN
INSERT (dbid, db_type, ip, reason, operator, is_active)
VALUES (s.dbid, s.db_type, s.ip, s.reason, s.operator, 'Y');
报错 ora-00900 啥意思? 语法没问题啊