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...
Main Author: | |
---|---|
Language: | unknown |
Published: |
2021
|
Subjects: | |
Online Access: | http://www.osti.gov/servlets/purl/7558 https://www.osti.gov/biblio/7558 |
id |
ftosti:oai:osti.gov:7558 |
---|---|
record_format |
openpolar |
spelling |
ftosti:oai:osti.gov:7558 2023-07-30T04:03:11+02:00 Oracle Database Y2K Protection Triggers Generators Cribbs, C A 2021-03-12 application/pdf http://www.osti.gov/servlets/purl/7558 https://www.osti.gov/biblio/7558 unknown http://www.osti.gov/servlets/purl/7558 https://www.osti.gov/biblio/7558 99 MATHEMATICS COMPUTERS INFORMATION SCIENCE MANAGEMENT LAW MISCELLANEOUS Data Base Management Computer Codes Modifications 2021 ftosti 2023-07-11T08:29:01Z 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; . Other/Unknown Material DML SciTec Connect (Office of Scientific and Technical Information - OSTI, U.S. Department of Energy) |
institution |
Open Polar |
collection |
SciTec Connect (Office of Scientific and Technical Information - OSTI, U.S. Department of Energy) |
op_collection_id |
ftosti |
language |
unknown |
topic |
99 MATHEMATICS COMPUTERS INFORMATION SCIENCE MANAGEMENT LAW MISCELLANEOUS Data Base Management Computer Codes Modifications |
spellingShingle |
99 MATHEMATICS COMPUTERS INFORMATION SCIENCE MANAGEMENT LAW MISCELLANEOUS Data Base Management Computer Codes Modifications Cribbs, C A Oracle Database Y2K Protection Triggers Generators |
topic_facet |
99 MATHEMATICS COMPUTERS INFORMATION SCIENCE MANAGEMENT LAW MISCELLANEOUS Data Base Management Computer Codes Modifications |
description |
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; . |
author |
Cribbs, C A |
author_facet |
Cribbs, C A |
author_sort |
Cribbs, C A |
title |
Oracle Database Y2K Protection Triggers Generators |
title_short |
Oracle Database Y2K Protection Triggers Generators |
title_full |
Oracle Database Y2K Protection Triggers Generators |
title_fullStr |
Oracle Database Y2K Protection Triggers Generators |
title_full_unstemmed |
Oracle Database Y2K Protection Triggers Generators |
title_sort |
oracle database y2k protection triggers generators |
publishDate |
2021 |
url |
http://www.osti.gov/servlets/purl/7558 https://www.osti.gov/biblio/7558 |
genre |
DML |
genre_facet |
DML |
op_relation |
http://www.osti.gov/servlets/purl/7558 https://www.osti.gov/biblio/7558 |
_version_ |
1772814138906509312 |