/SQL/Select only columns that are not empty oracle sql

Select only columns that are not empty oracle sql

select 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.table_name = 'SHRDGMR'
AND (NUM_DISTINCT > 0 or density > 0)
order by col.column_id;

Select only columns that are not empty oracle sql

select 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.table_name = 'REPLACE THIS WITH YOUR TABLE NAME'
AND NUM_DISTINCT > 0 
order by col.column_id;

Similar codes

0 vote214 views1 answer
Clone table structure mysql
SQL
36 votes214 views6 answers
Rename table sql
SQL
0 vote207 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote209 views1 answer
Soql user profile
SQL
0 vote201 views1 answer
Sql developer search all packages for text
SQL
1 vote202 views1 answer
DATE_SUB postgres
SQL
0 vote232 views1 answer
Openquery update linked server
SQL
1 vote192 views3 answers
How to truncate foreign key constraint table
SQL
0 vote222 views1 answer
Create query in where clasue
SQL
1 vote190 views1 answer
Mysql server does not start mac
SQL