/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 vote133 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote141 views1 answer
Plpgsql raise notice
SQL
0 vote144 views1 answer
Postgresql create query
SQL
2 votes150 views2 answers
How to run postgresql in linux
SQL
0 vote139 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
3 votes133 views4 answers
Psql list tables in schema
SQL
10 votes146 views2 answers
Mysql drop database if exists
SQL
4 votes164 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
6 votes190 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes131 views1 answer
APEX elapsed time
SQL