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 vote177 views1 answer
Oracle running queries sql
SQL
0 vote163 views1 answer
Luu ckeditor vao mysql
SQL
4 votes191 views3 answers
Sqlite show columns
SQL
0 vote171 views1 answer
Postgresql not in alternative
SQL
1 vote164 views2 answers
Mysql current user
SQL
0 vote178 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote174 views1 answer
Narural join
SQL
7 votes170 views2 answers
Create index mysql
SQL
0 vote193 views1 answer
Mysql sum with group by
SQL
0 vote168 views1 answer
Oracle shrink table
SQL