declare v_i integer;
for v_i in 1..12 do delete from SCHEMANAME.TABLENAME where PERDE = v_i;
does not work / run in TOAD
error : SAP Hana Database Error: sql syntax error: line 2 col 13 (at pos 23)
when I copy this code 1:1 to HANA Studio and press F8 in HANA Studio it works.
Is there a option to run this code like in HANA Studio?