Oracle search columns in schema

select t.owner as schema_name,
       t.table_name , col.column_name
from sys.all_tab_columns col
inner join sys.all_tables t on col.owner = t.owner 
                              and col.table_name = t.table_name
where col.column_name = ''
and col.owner not in ('')
order by col.owner, 
         col.table_name;

Similar codes

4 votes425 views2 answers
Delete all table oracle
SQL
1 vote385 views1 answer
Drop table if exists oracle
SQL
0 vote372 views1 answer
Sql count * vs count 1
SQL
1 vote406 views2 answers
Intersect sql
SQL
6 votes421 views4 answers
Mysql group by month
SQL
0 vote360 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote383 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote377 views1 answer
SQL Server Enterprise
SQL
8 votes357 views1 answer
Mac restore mysql database command line
SQL
0 vote383 views1 answer
Datagrip execute procedure
SQL