在准备好的语句中重用匿名参数

你可以写

INSERT INTO REF_USER_ROLE_XRE  SELECt Param1, Param2, Param1,     (select to_char(sysdate, 'DD-MON-YY') from  dual)FROM     (SELECT ? AS Param1, ? AS Param2) params