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

0 vote247 views1 answer
Consulta alias con inner join
SQL
5 votes217 views2 answers
Oracle show procedures
SQL
0 vote197 views1 answer
Savepoint mysql script
SQL
0 vote215 views1 answer
Sql convert float to string
SQL
1 vote182 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote190 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote191 views1 answer
Mysql 8 error on identified by
SQL
15 votes187 views2 answers
Sql order by multiple columns
SQL
1 vote205 views1 answer
Limit offset order by mysql
SQL
25 votes202 views1 answer
How to update an attribute in MySQL
SQL