Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table personal_data_a(id number, born number, age number, weight number, name varchar2(100), surname varchar2(100));
create table personal_data_b(id number, born number, age number, weight number, name varchar2(100));
insert into personal_data_a values(1,null,2,501,'John','Doe');
1 rows affected

insert into personal_data_a values(2,null,3,501,'John','Doe');
1 rows affected

--Get the ID column from a PERSONAL table.
--
--#4: Get the IDs from the XMLType.
select id
from
(
	--#3: Convert the XML to an XMLType.
	select xmltype(personal_xml) personal_xmltype
	from
	(
		--#2: Convert the SQL to XML.
		select dbms_xmlgen.getxml(v_sql) personal_xml
		from
		(
			--#1: Use data dictionary to create SQL statement that may or may not include
			-- the surname predicate.
			select max(replace(replace(
			q'[
				Select ID
				from #TABLE_NAME#
				where 
				born is null
				or age < 1
				or weight > 500
				or (name = 'John' #OPTIONAL_SURNAME_PREDICATE#)
			]'
			, '#TABLE_NAME#', table_name)
			, '#OPTIONAL_SURNAME_PREDICATE#', case when column_name = 'SURNAME' then
				'and surname = ''Doe''' else null end)) v_sql
			from all_tab_columns
			--Change this literal to the desired table.
			where table_name = 'PERSONAL_DATA_A'
		)
	)
	where personal_xml is not null
)
cross join xmltable
(
	'/ROWSET/ROW'
	passing personal_xmltype
	columns
		id number path 'ID'
);


ID


1

2