Oracle Data Validation Examples: Regular Expressions

Pubblicato il: 05 luglio 2021
sul canale di: DataResearchLabs

271

This video walks you through 14 regular expression data validation test case examples. There are validation tests for phone numbers, social security numers, zip5 and/or zip9, text only, numeric only, no leading or trailing whitespace, only lowercase, only uppercase, titlecase, email addresses, and urls. Included also are two tips on web searches to support use of regular expressions: (1) search on "regular expression X" where X is the data element to validate (eg: phone number), and (2) search on "regular expression builder" (or tester) for excellent free tools that let you dial in a regular expression against text data all on a simple web page.

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:08 - Introducing Rule Set #7 - Regular Expressions
0:31 - Two Web Search Tips (Existing RegEx Strings & RegEx Builders)
1:54 - Demo: T045 - T049
5:53 - Demo: T050 - T052
7:25 - Demo: T053 - T054
8:45 - Demo: T055 - T058
13:20 - How to Download SQL Scripts in this Video
14:41 - The End

Downloads:
- Rule Set #7: 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

In questa pagina del sito puoi guardare il video online Oracle Data Validation Examples: Regular Expressions della durata di ore minuti seconda in buona qualità , che l'utente ha caricato DataResearchLabs 05 luglio 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 271 volte e gli è piaciuto 3 spettatori. Buona visione!

3,172