rem -----------------------------------------------------------------------
rem Filename:   ora_gdpr_cols.sql
rem Purpose:    Extracts candidate columns for personal, sensitive, critical, ... data
rem Date:       14-Feb-2017
rem Author:     meo
rem
rem Updated By  meo
rem Description Rudimental...
rem -----------------------------------------------------------------------


column DATA_TYPE format a20
select OWNER, TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH
 from dba_tab_columns
 where OWNER not in ('SYS','SYSTEM','APEX_030200','OUTLN','ORDDATA','ORDSYS')
   and (column_name like '%FIRST%NAME%' OR
	column_name like '%LAST%NAME%' OR
	column_name like '%SURNAME%' OR
	column_name like '%FULL%NAME%' OR
	column_name like '%USER%NAME%' OR
	column_name like '%COGNOME%' OR
	column_name like '%MAIL%' OR
	column_name like '%POSTA%' OR
	column_name like '%TELEP%' OR
	column_name like '%EXTENS%' OR
	column_name like '%TELEF%' OR
	column_name like '%SSN%' OR
	column_name like '%FISC%' OR
	column_name like '%IBAN%' OR
	column_name like '%CCARD%' OR
	column_name like '%BANK%' OR
	column_name like '%BANCA%' OR
	column_name like '%PAYP%' OR
	column_name like '%PASS%' OR
	column_name like '%RELIGIO%' OR
	column_name like '%ACUZIE%' OR
	column_name like '%PATHOL%')
 order by 1,2,3;