step6

-- Run this once — it generates ready-to-run queries
SELECT 'SELECT ''' || table_name || ''' AS table_name, COUNT(*) AS rows_last_45_days FROM ' || 
       table_name || ' WHERE INTERNTIMESTAMP >= SYSDATE - 45;'
FROM   user_tab_columns
WHERE  UPPER(column_name) = 'INTERNTIMESTAMP'
  AND  data_type LIKE 'TIMESTAMP%'
ORDER BY table_name;