oracle 查看表结构或是表信息

?

1 2 3 4 5 6 7 8 9 10 11 12 13

select t.COLUMN_NAME,        decode(s.DATA_TYPE,               'DATE',               'DATE',               s.DATA_TYPE || '(' || s.DATA_LENGTH || ')'),        t.COMMENTS   from all_col_comments t, all_tab_columns s  where t.Table_Name = 'BOND_HOLDERMEETINGM'    and s.Table_Name = 'BOND_HOLDERMEETINGM'    and t.COLUMN_NAME = s.COLUMN_NAME  order by t.column_name;

　　

参考学习网址：

https://www.jb51.net/article/280815.htm