/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

1 vote173 views1 answer
Insert into sql
SQL
3 votes192 views1 answer
Oracle nextval
SQL
0 vote200 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote211 views1 answer
Get sum sqlite android
SQL
0 vote199 views1 answer
Search db for table name
SQL
2 votes232 views2 answers
How to run postgresql in linux
SQL
4 votes159 views1 answer
And or sql order of operations
SQL
0 vote209 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote229 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote205 views1 answer
Oracle sql alter view add column
SQL