Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check tables with specific columns

user545194Jun 20 2022

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)
This post has been answered by Solomon Yakobson on Jun 20 2022
Jump to Answer

Comments

Post Details

Added on Jun 20 2022
#sql
10 comments
316 views
3 mentions