Oracle SQL - Select all table names from all schemas

Try something like:

select owner, table_name, column_name from dba_tab_columns where column_name in ('EMPLOYER_CODE','DATA_PRECISION');

You'll need DBA level access.  If you don't have it, try all_tab_columns but you will miss tables you don't have permissions to see.

slightwv's solution would give you tables that have at least one of the columns.

If the table needs to have both columns, try this:

SELECT owner, 
       table_name 
FROM   dba_tab_columns 
WHERE  column_name IN ( 'EMPLOYER_CODE', 'DATA_PRECISION' ) 
GROUP  BY owner, 
          table_name 
HAVING Count(1) > 1 

Select allOpen in new window

'DATA_PRECISION' is an attribute like Table_name of the tables which gives you the column length. I need the data_precision of the "Employer_code" column where ever employer_code exist

The online docs have all the columns available:
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/ALL_TAB_COLUMNS.html#GUID-F218205C-7D76-4A83-8691-BFD2AD372B63

Thanks all