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

6 votes140 views1 answer
Oracle rank
SQL
0 vote137 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote137 views1 answer
Mssql last day of month
SQL
0 vote136 views1 answer
Trigger vérifier stock
SQL
13 votes119 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote126 views1 answer
Oracle sql winter time change
SQL
1 vote134 views1 answer
Multiple count in sql
SQL
0 vote134 views1 answer
Get role postgres
SQL
1 vote130 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote90 views1 answer
Select all domains of database firbird
SQL