/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

2 votes115 views1 answer
Sql view column data type
SQL
0 vote163 views1 answer
How to drop columns with constraint from a table in sql script
SQL
1 vote183 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
2 votes152 views1 answer
Oracle sql drop column if exists
SQL
0 vote171 views2 answers
Mysql get routine parameter list
SQL
0 vote155 views1 answer
Edit a field mysql terminal
SQL
3 votes196 views1 answer
Sql online test questions and answers
SQL
11 votes189 views1 answer
Oracle export view ddl
SQL
0 vote217 views1 answer
Postgresql remove new line from string
SQL
0 vote167 views1 answer
Find all tables where column name exists oracle
SQL