Oracle Data Validation Examples: Numeric and Date Fields

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/sql_scripts/blob/main/oracle/data_validation/rule_set_04__numeric_values.md
- Rule Set #5: https://github.com/DataResearchLabs/sql_scripts/blob/main/oracle/data_validation/rule_set_05__date_values.md
- Multi-Platform Data Validation Scripts: https://github.com/DataResearchLabs/sql_scripts/blob/main/data_validation_scripts.md


Watch related playlist videos:
- https://www.youtube.com/playlist?list=PLVHoUDdbskURXEfHF6s8vZo9oSx4JPkcF


Connect with me on social media:
- LinkedIn: https://www.linkedin.com/in/mpiercead576/
- YouTube: https://www.youtube.com/channel/UCQciXv3xaBykeUFc04GxSXA
- GitHub: https://github.com/DataResearchLabs


Subscribe to my YouTube Channel:
- https://www.youtube.com/channel/UCQciXv3xaBykeUFc04GxSXA?sub_confirmation=1


Background Music (via YouTube "always free" Audio):
- "Rewind" by Ofshane: https://www.youtube.com/channel/UC34Wh4ysdP50H-ThbZFFfsA


#Oracle #automation #datavalidation