oracle 一些有用的查询

– 查询不为空的字段，并用逗号连起来 ；Table_Name 表名nullable 是否为空 N表示不为空

select  t.table_name ,    wm_concat(t.column_name)
from user_tab_columns  t 
left join user_col_comments c on  t.table_name = c.table_name and t.column_name = c.column_name
where t.Table_Name ='DISP_PRES_OTHER' and t.nullable = 'N'
group by t.table_name  ;