/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

5 votes109 views2 answers
Oracle find all tables with column name
SQL
0 vote100 views1 answer
Oracle select invalid views
SQL
5 votes135 views4 answers
Restart the psql server windows
SQL
0 vote107 views1 answer
Find all tables where column name exists oracle
SQL
1 vote135 views1 answer
Hangfire clear all jobs
SQL
0 vote102 views1 answer
Delete double on SQL with multiple primary keys
SQL
2 votes100 views1 answer
Ssh mysql port forwarding
SQL
3 votes96 views1 answer
Postgres update column with value from another table
SQL
0 vote107 views1 answer
How to convert external table to managed table in hive
SQL
2 votes103 views1 answer
How to search table name in stored procedure in sql server
SQL