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

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...