Thursday, June 5, 2014

How to search column name in all database table in oracle?

 How to search column name in all database table  in oracle?

SELECT * FROM ALL_TAB_COLUMNS
WHERE COLUMN_NAME LIKE
'%COLUMN_NAME%'