Hello expert,
I need to go to the DBA with a script to delete rows in two tables.
Wrote
DELETE FROM J3131_ACP_D_NOTE_SEGMENT
where NOTE_ID = 798105 and SEGMENT_ID in (2359467, 2359468, 2359469);
DELETE FROM J3131_ACP_D_NOTE_SEGMENT_MKT
where NOTE_ID = 798105 and SEGMENT_ID in (2359467, 2359468, 2359469);
COMMIT;
But it only executes the first statement
Have tried running the two statements in separate queries with positive
result. But when combined only the first goes.
Was told by the DB expert that the semicolon is needed after
the first statement, Is he wrong?
Thanks.
Allen in Dallas