/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 vote252 views1 answer
Sql find table by name
SQL
1 vote245 views2 answers
Sql where is not number
SQL
19 votes254 views2 answers
Mysql add column after another
SQL
1 vote253 views1 answer
Is sql fast
SQL
0 vote274 views1 answer
Search from comma separated values in sql server
SQL
1 vote260 views2 answers
Sql queries practice
SQL
0 vote321 views1 answer
Oracle calculate statistics on partition
SQL
1 vote236 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote257 views2 answers
How to tun mysql on ubunto
SQL
0 vote264 views1 answer
Normalization in database 2nd normal form
SQL