CREATE TABLE table_delete

(

    id1 NUMBER(2,0)

,   desc1 VARCHAR(2)

);

INSERT INTO table_delete (id1, desc1) VALUES (1, 'A');

INSERT INTO table_delete (id1, desc1) VALUES (2, 'B');

INSERT INTO table_delete (id1, desc1) VALUES (3, 'C');

DELETE table_delete WHERE id1 = 1;

SELECT id1, desc1 FROM table_delete;

id1   desc1

----- -----

2     B

3     C

DELETE ( SELECT 1 FROM table_delete WHERE id1 IN (1,2) );

SELECT id1, desc1 FROM table_delete;

id1   desc1

----- -----

3     C