/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 vote235 views1 answer
Mysql foreach insert
SQL
1 vote231 views1 answer
Psql filed name alter
SQL
2 votes228 views2 answers
Mysql limit
SQL
1 vote238 views1 answer
Psql connections
SQL
0 vote247 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote227 views1 answer
Mysql workbench primary key
SQL
5 votes229 views1 answer
Sql use database
SQL
2 votes251 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote228 views2 answers
Sql now - 1 day
SQL
1 vote227 views1 answer
Get url of cpanel database hostname
SQL