oracle数据库获取表的列名以及列名的注释，并按表中字段原来的顺序显示

1.如果是单用户，可以使用以下

select nvl(a.column_name, '无注释') as field,       nvl(a.comments, '无注释') as title  from user_col_comments a inner join user_tab_columns b on (a.table_name = b.table_name and                                  a.column_name = b.column_name) where a.table_name = upper(#{tableName}) order by n.column_id

2.如果是多用户，想从本数据库获取其他数据库的信息

select nvl(m.column_name, '无注释') as field,       nvl(comments, '无注释') as title  from dba_col_comments m inner join dba_tab_columns n on (m.table_name = n.table_name and                                 m.owner = n.owner and                                 m.column_name = n.column_name) where table_name = upper(#{tn})   and owner = upper(#{sn}) order by n.column_id