-- 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;
Related Posts
Introducing Read Replicas
Today, we are launching support for Postgres Read Replicas. You can use Read Replicas to: Distribute load across…
I Hired an AI as a Developer – This Is What Happened
There have been many discussions around whether AI is threatening developer’s jobs. Some say they are very close…
How a history-aware retriever works?
The history-aware retriever discussed in this post is the one returned by the create_history_aware_retriever function from the LangChain…