Oracle Data Validation Examples: Numeric and Date Fields

Veröffentlicht am: 30 Juni 2021
auf dem Kanal: DataResearchLabs

253

This video walks you through 11 standard data validation test case examples. The numeric validation tests check for nulls, negative numbers, inside a specific range, in a list, not in a list, and comparing multiple numeric fields or doing calculations. The date validation tests check for nulls, dates inside a range, make sure there is or is not a time part, and comparing multipe date fields. There is also a bonus tip showing how to handle date overlaps when joining tables...ensuring that table#1 start/end dates overlaps table#2 start/end dates when you pull them together in a join.

You can refactor and re-use the samples in your projects. The scripts in the demo are all out on Github along with 66 total sample validation tests along with a basic and an advanced script for automating the tests.

------ Chapter Timestamps (click to jump forward): ----------------------------
0:00 - Intro
0:07 - Introducing Rule Set #4 - Numeric Values
0:18 - Demo: T010 - Numeric Not Null
0:38 - Demo: T011 - Numeric Not Negative
1:01 - Demo: T012 - Numeric in Numeric Range
2:50 - Demo: T013/T014 - Numeric In/Out of Value List
4:39 - Demo: T015 - Numeric Multi Field Compare
5:27 - Introducing Rule Set #5 - Date Values
5:53 - Demo: T016 - Date Not Null
6:19 - Demo: T017 - Date in Range
8:32 - Demo: T018/T019 - Date Not/Does Have Time Part
10:47 - Demo: T020 - Date Multi Field Compare
11:37 - Bonus Tip: Joining Tables with 2 Pairs of Start-End Date Overlaps
14:37 - How to Download SQL Scripts in this Video
15:58 - The End

Downloads:
Rule Set #4: https://github.com/DataResearchLabs/s...
Rule Set #5: https://github.com/DataResearchLabs/s...
Multi-Platform Data Validation Scripts: https://github.com/DataResearchLabs/s...

Watch related playlist videos:
   • Oracle SQL Scripts for Data Analysts

Connect with me on social media:
LinkedIn:   / mpiercead576
YouTube:    / @dataresearchlabs
GitHub: https://github.com/DataResearchLabs

Subscribe to my YouTube Channel:
   / @dataresearchlabs

Background Music (via YouTube "always free" Audio):
"Rewind" by Ofshane:    / @ofshane

#Oracle #automation #datavalidation

Auf dieser Seite können Sie das Online-Video Oracle Data Validation Examples: Numeric and Date Fields mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer DataResearchLabs 30 Juni 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 253 Mal angesehen und es wurde von 2 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

324