oracle 查看表的定义

select t.table_name 表名,
c.comments 字段名称,
t.column_name 字段编码,
t.data_type || ‘(‘ || to_char(t.data_length) || ‘)‘ 类型
FROM user_tab_cols t, user_col_comments c
WHERE c.table_name = t.table_name
and c.column_name = t.column_name
and t.hidden_column = ‘NO‘
and c.TABLE_NAME In (‘‘, ‘‘, ‘)
order by c.TABLE_NAME, t.column_name

原文：http://www.cnblogs.com/Roube/p/4710124.html