查询拼接SQL语句
SELECT 'UPDATE JXKH66 SET JXKH6612='''||A01_FUNCTION.A02_A0215_ALL||''',JXKH6614=TO_DATE('''||TO_CHAR(A01_FUNCTION.A02_CURDUTYTIME, 'YYYY-MM-DD')||''',''YYYY-MM-DD'')'||' WHERE A00='''||A01.A00||''';' FROM A01 INNER JOIN B01 ON A01.ZDYXA0176 = B01.B00 LEFT JOIN A01_FUNCTION ON A01_FUNCTION.A00 = A01.A00 LEFT JOIN(BJ801) BJ801_ZDYXA0157 on A01.ZDYXA0157 = BJ801_ZDYXA0157.DMCOD WHERE 1=1 AND A01.A00 IN ('d6d3ad33-c017-4b7e-addf-53228452c63c','23e14f8e-2a72-4016-bd6a-425d3ceb0bae') ORDER BY (B01.PINDEX) ASC, A01.PINDEX ASC;