Oracle Data Validation Examples: Text Fields

Veröffentlicht am: 01 Juli 2021
auf dem Kanal: DataResearchLabs

554

This video walks you through 24 text field data validation test case examples. There are validation tests for nulls and nullstrings, no leading or trailing spaces, in or not in a value ilst, and text field length. There are upper case, lower case, alpha, and numeric characters checks. There are bad characters tests for single quotes, quotes, carriage returns, line feeds, tabs, non-breaking-spaces, em-dashes, vertical tabs, form feeds, next lines, and many other funky character intercepts. There is a validation test for only allowing or only disallowing specific characters in a [list] you specify. Finally there are "soft" data conversion tests to verify a text field is numeric or one of many different date formats so you can intercept and notify with a rejection code prior to converting and erroring.

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 #6 - Text Values
3:02 - Demo: T021 - T025
5:48 - Demo: T026 - T029
10:59 - Demo: T030 - T038
17:09 - Demo: T039 - T044
23:35 - How to Download SQL Scripts in this Video
24:55 - The End

Downloads:
Rule Set #6: 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: Text Fields mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer DataResearchLabs 01 Juli 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 554 Mal angesehen und es wurde von 3 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

324