/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 votes309 views5 answers
Sql select
SQL
2 votes277 views1 answer
Sql get the name of user pc
SQL
3 votes282 views2 answers
Sql select data from last week
SQL
8 votes299 views1 answer
Oracle search text in all packages
SQL
1 vote307 views1 answer
Postgresql if 0 then 1
SQL
1 vote263 views1 answer
Oracle start job
SQL
0 vote264 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote347 views1 answer
Oracle simple quote
SQL
0 vote267 views1 answer
Docker export psql sql
SQL
0 vote314 views1 answer
Check if mysql db is used
SQL