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 vote113 views1 answer
Oracle array
SQL
6 votes109 views1 answer
Sqlite foreign key
SQL
16 votes113 views1 answer
Mssql int max value
SQL
7 votes104 views1 answer
Sql server convert string to date
SQL
5 votes106 views4 answers
Mysql update column with value from another table
SQL
1 vote64 views1 answer
Ms sql how to see active job current run time
SQL
0 vote117 views1 answer
How to set up an anonymous function to variable in swift
SQL
1 vote108 views1 answer
Sql server cast date dd/mm/yyyy
SQL
3 votes109 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
8 votes117 views1 answer
How to check mysql version in xampp
SQL