Search all Oracle tables for a specific column or table name.


--Remove the comment for the appropriate restriction.
SELECT table_name, column_name
FROM all_tab_columns
--WHERE column_name LIKE '%%'
--WHERE table_name LIKE '%%'
ORDER BY table_name, column_name


Downloads

Find Tables that Contain Column
A Crystal Report that will search Oracle for columns that match a criteria.

No tags