Skip to content

Instantly share code, notes, and snippets.

@johnboychan johnboychan/ppipmi
Last active Mar 20, 2018

What would you like to do?
-- run in uoepp
select ut.table_name, utc.*
from user_tables ut, user_tab_columns utc
where ut.table_name = utc.table_name
--and ut.table_name like 'PPIPMI%'
and utc.column_name IN ('ASSIGN_ID', 'ASSIGNMENT_ID', 'PERSON_ID');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.