step2

Source: Dev.to

Example Query

-- Test just ONE table to see if anything works
-- Replace 'YOUR_TABLE' with an actual table name from your 45 columns

SELECT 
  'Test on: ' || table_name as test,
  (SELECT COUNT(*) FROM user_tables WHERE table_name = 'YOUR_TABLE') as stats_count,
  (SELECT COUNT(*) FROM "YOUR_TABLE") as actual_count,
  (SELECT COUNT(*) FROM "YOUR_TABLE" WHERE INTERNTIMESTAMP >= SYSDATE - 45) as recent_count,
  (SELECT MIN(INTERNTIMESTAMP) FROM "YOUR_TABLE") as oldest,
  (SELECT MAX(INTERNTIMESTAMP) FROM "YOUR_TABLE") as newest
FROM DUAL;