/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

24 votes182 views4 answers
Mysql datetime
SQL
0 vote187 views1 answer
Postgres dump sql insert
SQL
18 votes173 views3 answers
Mysql number format
SQL
0 vote156 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote182 views1 answer
Sql change primary key to composite key
SQL
0 vote163 views1 answer
How to access to mysql without root
SQL
0 vote153 views1 answer
Ms Sql set us timezone
SQL
13 votes161 views5 answers
Oracle list tables
SQL
0 vote225 views1 answer
Sql select without column name
SQL
16 votes203 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL