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

3 votes229 views2 answers
Find string in stored procedure sql server
SQL
0 vote284 views1 answer
Sql server query all database objects
SQL
0 vote167 views1 answer
Postgresql parse json array
SQL
0 vote171 views1 answer
How to make case insensitive in sql
SQL
6 votes189 views2 answers
Mysqldump password in file
SQL
1 vote166 views1 answer
Sql auto timestamp
SQL
0 vote216 views1 answer
Rabbitmq service not starting
SQL
3 votes164 views2 answers
Mysql add 2 hours
SQL
0 vote172 views1 answer
Sql server express download
SQL
0 vote175 views1 answer
Tsql cmd exec script from file
SQL