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

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...