I need to find credit card numbers hidden in text columns, using Oracle 11g and SQLPlus
During an audit it was discovered that users where hiding customers credit card info in text columns like a description or notes column vs. where it belongs. We can't filter it on the front-end because it's 3rd party software and we are unable to make changes and the vender refuses to make changes based on our needs.
So I need to use some SQL commands to scan columns for matches. Been looking at the REGEXP_SUBSTR commands but I have to write something that will scan all the columns in a particular schema with applying the expression.
Has anyone accomplished this task already ? If so any direction or examples are greatly appreciated.