/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 vote340 views1 answer
Postgres list all triggers
SQL
1 vote290 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
25 votes319 views6 answers
Import database mysql command line
SQL
2 votes281 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote293 views1 answer
Drop unique
SQL
0 vote325 views1 answer
Mysql update all record removing 2 hours from column
SQL
10 votes303 views3 answers
Join multiple tables sql
SQL
18 votes279 views2 answers
Sql inner join
SQL
0 vote296 views1 answer
Select odd records sql
SQL
0 vote321 views1 answer
Sql max of two values
SQL