/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 vote183 views1 answer
How to add more columns to a table in mysql
SQL
1 vote226 views1 answer
Continue in sql
SQL
5 votes248 views1 answer
Oracle sysdate - 1 month
SQL
1 vote187 views1 answer
Mysql dump specific tables
SQL
0 vote296 views1 answer
Mysql select field if condition
SQL
1 vote180 views2 answers
Backup table mssql
SQL
4 votes174 views2 answers
Sqlalchemy_database_uri for mysql
SQL
5 votes177 views3 answers
Sql max value in column
SQL
0 vote162 views1 answer
Mysql with
SQL
5 votes252 views4 answers
Sql check
SQL