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
SELECT
_V_BACKUP_HISTORY.STATUS
, _V_BACKUP_HISTORY.DBNAME
, _V_BACKUP_HISTORY.USERNAME
, _V_BACKUP_HISTORY.STARTTIME
, _V_BACKUP_HISTORY.LASTUPDATE
, EXTRACT(epoch FROM ( _V_BACKUP_HISTORY.STARTTIME - _V_BACKUP_HISTORY.LASTUPDATE ))*INTERVAL '1 SECOND' AS DIFF_HHMMM
SS
, _V_BACKUP_HISTORY.LOGFILE
FROM _V_BACKUP_HISTORY
WHERE 1=1
--AND _V_BACKUP_HISTORY.STATUS = 'ACTIVE'
ORDER BY STARTTIME desc
LIMIT 300
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 !!!!