/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 vote407 views1 answer
Sql alternative to max statement
SQL
2 votes402 views1 answer
Creating a view SQL
SQL
0 vote362 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
4 votes325 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
10 votes353 views5 answers
Mysql create user
SQL
0 vote349 views1 answer
Create or replace view postgress
SQL
0 vote360 views1 answer
How to find lowest in sql
SQL
1 vote406 views2 answers
Drop table with constraints
SQL
0 vote304 views1 answer
FindAllBy
SQL
-1 vote341 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL