Oracle Database Y2K Protection Triggers Generators

• Main Author: Cribbs, C A
• Language: unknown
• Published: 2021
• Subjects: 99 MATHEMATICS; COMPUTERS; INFORMATION SCIENCE; MANAGEMENT; LAW; MISCELLANEOUS; Data Base Management; Computer Codes; Modifications; DML
• Online Access: http://www.osti.gov/servlets/purl/7558; https://www.osti.gov/biblio/7558

I developed PL/SQL code that generates or modifies PL/SQL “BEFORE EACH ROW” triggers to protect database date columns from Y2K non-compliant date input (from all sources) into the database. A function is imbedded in the triggers that uses the “RR” year formatted date conversion. For each table with at least one date column and with INSERT/UPDATE/DELETE trigger(s), my code inserts date conversion code into the existing trigger(s). For INSERT/UPDATE not in a trigger(s), my code creates a trigger for the absent DML command(s). Designed to be: Transferable to other servers with minimum effort; A uniform and consistent problem solution with easy implementation, testing, and configuration management. No need to manually code and edit SQL trigger files: Modifies existing triggers; Creates needed triggers; Self documented (output comments with code); SQL files configuration management ready. Can customize the: Date conversion function; Code modifications for the trigger; Universal lookup/key; .