/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

3 votes281 views1 answer
How to find names includes in sql
SQL
13 votes272 views5 answers
Sql default
SQL
0 vote271 views1 answer
Mysql search multiple tables
SQL
0 vote264 views1 answer
Call function in query sql server
SQL
0 vote260 views2 answers
Postgresql get long running queries
SQL
0 vote268 views1 answer
Nth max in my sql
SQL
0 vote290 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote271 views1 answer
Mysql pad zeros
SQL
4 votes294 views2 answers
Float postgres
SQL
2 votes284 views1 answer
Sql server current date minus 5 years
SQL