-- 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
NativeFlow: A Tailwind-Like, Object-Based React Native UI Library 🚀
In the world of React Native development, UI styling can sometimes be a pain point, especially for those…
Uncovering Open Source B2B Ecommerce
At Medusa, we recently published our Perspective on Open Source B2B ecommerce as part of the launch of…
Hey, great work on your project! 🙌 I noticed one of the links seems to be broken(https://codebeautify.org/jsoncompare). If you’re looking for a working JSON comparison tool, feel free to check out mine: https://formatjsononline.com/json-compare
JSON Diff: Comparing JSON Data Effectively keploy ・ Nov 18 ’24 #webdev #javascript #programming #tutorial