SELECT * FROM ALL_TAB_COLUMNS C, ALL_OBJECTS O
WHERE C.TABLE_NAME = O.OBJECT_NAME
AND C.OWNER = O.OWNER
AND O.OBJECT_TYPE = 'TABLE'
AND COLUMN_NAME LIKE 'EMPLOYEE_ID'
AND C.OWNER = 'YOUR_SCHEMA_NAME
AND TABLE_NAME NOT LIKE 'BIN%'
PS: Replace YOUR_SCHEMA_NAME
No comments:
Post a Comment