/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 vote230 views1 answer
Mssql dockere
SQL
0 vote251 views3 answers
Postgres trim string
SQL
5 votes205 views1 answer
Oracle ora-00054 causes
SQL
1 vote226 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote226 views1 answer
Selecting duplicates
SQL
0 vote219 views1 answer
Sql select with apostrohpe
SQL
0 vote227 views1 answer
Mysql add to number
SQL
7 votes205 views3 answers
How to check table name in current database sql
SQL
4 votes224 views1 answer
Mysql copy table with new name
SQL
0 vote229 views1 answer
Mysql sql.gz
SQL