Oracle: monitoring long tasks

1	SELECT start_time, username, target, sofar blocks_read, totalwork total_blocks, round(time_remaining/60) minutes FROM v$session_longops WHERE sofar <> totalwork;

Oracle: remove duplicate records

Tom said: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:15258974323143

Git tips from the trenches

https://ochronus.com/git-tips-from-the-trenches/#null

PL/SQL: how to deal with nullable variables in query

1	where decode(column, variable, 0) is not null