I guess many of you had the same scenario where we want to know how to find all tables containing a column name in an Oracle database, so I found an useful and quick query for it:
SOLUTION:
SELECT OWNER,TABLE_NAME,COLUMN_NAME,DATA_TYPE,NULLABLE FROM ALL_TAB_COLUMNS WHERE column_name = upper( 'nombrecolumna');
Hoping this will help you guys,
See you next time.
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Buenas, Muchos habrán tenido que buscar todas las tablas que tienen un campo especifico en Oracle, y el query mas pequeño y util que encontre para esto es el siguiente:
SOLUCION:
SELECT OWNER,TABLE_NAME,COLUMN_NAME,DATA_TYPE,NULLABLE FROM ALL_TAB_COLUMNS WHERE column_name = upper( 'nombrecolumna');
Espero les sea util, saludos.
