You will need to write a sqlplus script to do an execute immediate on generated sql statements, You first have to build the 'select' statement for the tables that have the date column you are looking for:
with names as
( select owner, table_name, column_name
where column_name like '%LAST_ANALYZED'
and data_type = 'DATE' )
select 'select * from ' || owner || '.' || table_name || ' where ' || 'trunc( ' || column_name || ' ) >= trunc( sysdate )'