1.拼接同一字段中所有的值(oracle)
wmsys.wm_concat(字段名)
2.查询该节点下所有子节点,包括子节点的子节点
select connect_by_root item_id
from 表名 t
where level>1 and connect_by_root item_id=3
connect by prior t.item_id=t.parent_id
3.case t.type
when 1 then (select ......)
when 2 then (select ......)
end as type
from .......
4.select table_name ,column_name from all_tab_columns;