/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 vote132 views1 answer
Lister les index d'une table oracle
SQL
1 vote175 views1 answer
Oracle select row max date
SQL
0 vote200 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
0 vote160 views1 answer
How to select a row in sql
SQL
0 vote160 views1 answer
Sql revert migration
SQL
0 vote150 views2 answers
Tsql row number
SQL
1 vote148 views1 answer
Postgresql convert text to float
SQL
2 votes168 views1 answer
Postgresql transaction
SQL
0 vote146 views1 answer
Mysql read row
SQL
0 vote151 views1 answer
Initcap in mysql
SQL