software

步骤2

发布: (2025年12月4日 GMT+8 04:45)
1 min read
原文: Dev.to

Source: Dev.to

示例查询

-- 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;
Back to Blog

相关文章

阅读更多 »

Oracle 合并 INTO

!Forem 徽标 https://media2.dev.to/dynamic/image/width=65,height=,fit=scale-down,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%...

比较3

sql SELECT 'ONLY_IN_US_1' AS location, t1.table_name FROM dba_tables t1 LEFT JOIN dba_tables t2 ON t1.table_name = t2.table_name AND t2.owner = 'GL...

比较2

sql SELECT CASE WHEN t1.table_name IS NOT NULL AND t2.table_name IS NULL THEN 'ONLY_IN_US_1' WHEN t2.table_name IS NOT NULL AND...

PostgreSQL 日志查看

Forem 徽标https://media2.dev.to/dynamic/image/width=65,height=,fit=scale-down,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%...