Hi,
"Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.11.0.0.0"
We need to select all tables with specific columns and add them to an audit table.
Problem: When querying the dba_tab_cols againt the col_audit_tab only the matching tables are returned. We need to find all tables that do not yet exist in the col_audit_tab and insert them.
We have attached some test data.
Thanks for your help!
test_data.zip (747 Bytes)