Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table mytable (id, valid) as
select 1, 'N' from dual
union all
select 2, 'Y' from dual;
2 rows affected

select * from mytable;


ID
VALID


1
N

2
Y


DECLARE
  type mytype_a is table of varchar2(32) index by binary_integer;
  mytype mytype_a;
BEGIN
  mytype (mytype.count + 1) := 'MYTABLE';

  for i in 1..mytype.count loop
    -- DELETE  FROM mytype(i) where valid ='N';
    execute immediate 'DELETE FROM ' || mytype(i) || ' where valid = ''N''';
  end loop;
END;
/
1 rows affected

select * from mytable;


ID
VALID


2
Y


rollback;
select * from mytable;


ID
VALID


1
N

2
Y


DECLARE
  type mytype_a is table of varchar2(32) index by binary_integer;
  mytype mytype_a;
  stmt varchar2(4000);
BEGIN
  mytype (mytype.count + 1) := 'MYTABLE';

  for i in 1..mytype.count loop
    stmt := 'DELETE FROM ' || mytype(i) || ' where valid = :valid';
    dbms_output.put_line(stmt);
    execute immediate stmt using 'N';
    dbms_output.put_line('Deleted ' || sql%rowcount || ' row(s)');
  end loop;
END;
/
1 rows affected

dbms_output:
DELETE FROM MYTABLE where valid = :valid
Deleted 1 row(s)

select * from mytable;


ID
VALID


2
Y


rollback;
select * from mytable;


ID
VALID


1
N

2
Y


DECLARE
  tables sys.odcivarchar2list := new sys.odcivarchar2list();
  stmt varchar2(4000);
BEGIN
  tables.extend;
  tables (tables.count) := 'MYTABLE';

  for i in 1..tables.count loop
    stmt := 'DELETE FROM ' || tables(i) || ' where valid = :valid';
    dbms_output.put_line(stmt);
    execute immediate stmt using 'N';
    dbms_output.put_line('Deleted ' || sql%rowcount || ' row(s)');
  end loop;
END;
/
1 rows affected

dbms_output:
DELETE FROM MYTABLE where valid = :valid
Deleted 1 row(s)

select * from mytable;


ID
VALID


2
Y