Oracle Import table structure

gistfile1.sql

select t1.COLUMN_ID 序号,
       t1.COLUMN_NAME 列名,
       decode(t1.DATA_TYPE,
              'NUMBER',
              decode(t1.DATA_PRECISION,
                     null,
                     decode(t1.DATA_SCALE, 0, 'INTEGER', 'NUMBER'),
                     'NUMBER'),
              t1.DATA_TYPE) 数据类型,
       decode(t1.DATA_TYPE, 'NUMBER', t1.DATA_PRECISION, 'DATE', '', t1.DATA_LENGTH) 长度,
       t1.DATA_SCALE 小数位,
       decode(t3.constraint_type, 'P', '是', '') 主键,
       decode(t1.NULLABLE, 'Y', '是', '否') 允许空,
       t1.DATA_DEFAULT 默认值,
       t2.comments 说明
  from USER_TAB_COLS T1
  LEFT JOIN USER_COL_COMMENTS T2
    ON T1.TABLE_NAME = T2.table_name
   AND T1.COLUMN_NAME = T2.COLUMN_NAME
  LEFT JOIN user_constraints T3
    ON T1.COLUMN_NAME = T3.constraint_name
 WHERE T1.TABLE_NAME = upper('YOUR_TABLE_NAME')
 order by t1.COLUMN_ID