I can help with some of the issues you're facing.

Update a Flag Only If All Matching Conditions Fail Using Oracle SQL

Converting Oracle Timestamps to ISO-8601 Date Datatype: A Step-by-Step Guide