CODEWITHSUNDEEP
mysqloracle-databaseteradata-sql-assistant
soul shrestha
soul shrestha

Reputation: 125

Complex Sql queries to to validate

These are some of the complex sql queries asked to me in recent ETL testing interview:

What are the exact sql queries to validate:

1)wild characters check in my sql and oracle.

2)debit card and credit card numbers check in my sql and oracle.

3)email address validation in my sql and oracle.

4)SSN validation in my sql and oracle.

Could you please help me out?

Upvotes: 0

Views: 309

Answers (2)

Tarun Gupta
Tarun Gupta

Reputation: 1242

You can use the trigger that validate the things with regEx for validations

https://falseisnotnull.wordpress.com/2012/11/06/validating-data-using-a-trigger/

Upvotes: 0

AbhishekK
AbhishekK

Reputation: 89

All the validation can be done using the REGEXP_LIKE function in MySQL and oracle. Check documentation for detail.

Upvotes: 2

Related Questions