/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 vote195 views1 answer
Postgresql custom order by
SQL
0 vote169 views1 answer
Learn sqlite dart
SQL
0 vote181 views1 answer
Sql quary intervewi question
SQL
1 vote225 views1 answer
Sql sort column by date
SQL
0 vote179 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote185 views1 answer
Postpresql relation not found
SQL
0 vote167 views1 answer
List MySQL Table and Index Size
SQL
0 vote170 views1 answer
Postgres create database if not exists
SQL
21 votes174 views3 answers
Sql average
SQL
0 vote630 views1 answer
How to connect .sql data set to powerbi
SQL