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 vote367 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote298 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote282 views1 answer
Sql server bool select
SQL
1 vote301 views1 answer
Where date = max(date) in sql
SQL
0 vote304 views1 answer
SQL division of an integer by another integer get float CAST
SQL
1 vote288 views1 answer
Set autoincrement to 0
SQL
0 vote293 views1 answer
Sql check for null and empty string
SQL
6 votes294 views1 answer
Identify primary key in oracle table
SQL
1 vote308 views3 answers
Epoch to datetime
SQL
0 vote313 views1 answer
MySQL update with subquery
SQL