not so active anymore, yet still stuff and code that works in Perl, bash, sh, PLSQL, TSQL, NZPLSQL , XML, HTML, XSL, C#, Scala , Python, Teradata SQL, cmd batch scripts, Oracle , MySql some old Java stuff , Linux , DB2 , Sun Solaris , NSIS , VB 6.0 , some old Essbase VB API and plain English - all this in non-user friendly fashion combined with occasionally strong statements and opinions about IT best practices, Agile Development , energy ... dump end ...Wait - https://qto.fi
nzsql -qtr -d GS_DB -q -c \
"SELECT SCHEMA|| '.' || TABLENAME FROM _V_TABLE \
WHERE 1=1 AND TABLENAME NOT LIKE '_T%' and TABLENAME NOT LIKE '_VT_%' " \
| sort | { while read -r t ; do nzsql -qtr -d GS_DB \
-c "SELECT count(*) || ' ' || '$t' from $t ;"; done ; } | sort -n
Posts
No comments:
Post a Comment
- the first minus - Comments have to be moderated because of the spammers
- the second minus - I am very lazy at moderating comments ... hardly find time ...
- the third minus - Short links are no good for security ...
- The REAL PLUS : Any critic and positive feedback is better than none, so your comments will be published sooner or later !!!!