/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

-1 vote201 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote214 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
6 votes186 views4 answers
Sqlite drop table
SQL
0 vote178 views1 answer
Find largest table in mysql database
SQL
0 vote180 views1 answer
How to get employee having maximum experience in mysql
SQL
5 votes172 views2 answers
Create table
SQL
0 vote352 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
1 vote195 views1 answer
Altering the column name in MySQL to have a default value
SQL
6 votes249 views2 answers
How to get yesterday date in mysql
SQL
1 vote254 views1 answer
Ora-01950 no privileges on tablespace
SQL