Oracle Database Y2K Protection Triggers Generators

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...

Full description

Bibliographic Details
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
Description
Summary: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; .

Similar Items