Question

存储过程中SQL的in的内容为入参，在线等

CREATE OR REPLACE PROCEDURE xxx(
a IN CHAR

)

AS
BEGIN
INSERT INTO abc SELECT * from def WHERE gh in (a);
COMMIT;

END;
请问入参a怎么传才能相当于 INSERT INTO abc SELECT * from def WHERE gh in ('a','b','c');呢？

Answer 1

把insert作为动态SQL，然后拼上参数a，这样就可以了。

v_sql := 'INSERT INTO abc SELECT * from def WHERE gh in (' || a || ')';

然后执行动态SQL语句。