oracle 查看表结构或是表信息

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