INSTALLATION DOCUMENTS BY RAVI

Saturday, April 15, 2017

SQL query for finding table names with specified column

SELECT COLUMN_NAME, TABLE_NAME 
FROM ALL_TAB_COLUMNS 
WHERE COLUMN_NAME LIKE '%MyName%'

No comments:

Post a Comment

Perfect order of ODI export and import

  Smart Export / Import is the recommended way to achieve such a migration. This is the easiest way to make sure all the dependencies are ta...