Python Forum

I am facing an issue with the below Merge statement

cur.execute(('MERGE INTO NETSUITE.NET_TRANSACTION_LINES_EV as Target  '
	         'USING (SELECT  * FROM '
	         '(VALUES vals) '
	         'AS s (TRANSACTION_ID, TRANSACTION_LINE_ID, UNIQUE_KEY) '
	         ') AS Source '
	         'ON Target.UNIQUE_KEY = Source.UNIQUE_KEY '
	         'WHEN NOT MATCHED THEN '
	         'INSERT (TRANSACTION_ID, TRANSACTION_LINE_ID, UNIQUE_KEY) VALUES (Source.TRANSACTION_ID, Source.TRANSACTION_LINE_ID, Source.UNIQUE_KEY) '
	         'WHEN MATCHED THEN '
             'UPDATE SET TRANSACTION_ID=Source.TRANSACTION_ID, TRANSACTION_LINE_ID =Source.TRANSACTION_LINE_ID;'
	         .format( vals = [str(i) for i in records])))

i am passing values on the fly.
My records is has data like this :- [[1,2,3] , [7,8,9], [5,7,8]]
which I am assigning to 'vals = [str(i) for i in records])'.
Also the above code which I found on the internet is the syntax for MySQL and not Oracle. I think I would need to select from dual for the values on the fly