/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 vote329 views1 answer
How to get parent and child record in single query using sql
SQL
4 votes338 views2 answers
Dbms output
SQL
1 vote327 views1 answer
Use of now() in mysql
SQL
1 vote321 views1 answer
Sql drop with dependencies
SQL
0 vote316 views1 answer
Sql grant select only
SQL
1 vote321 views1 answer
How to get mysql db size
SQL
1 vote368 views1 answer
Sql first day quarter
SQL
0 vote328 views1 answer
How many rows affected in sqllite
SQL
0 vote339 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote312 views1 answer
Mysql begin statement
SQL