oracle数据字电自动生成技术

select  t.TABLE_NAME as ,
          column_name as  字段名称
,
          data_type as 字段类型
,
          data_length as 字段长度
,
          data_precision as 主键
,
         
          nullable as 空值
,
          data_scale as 索引
          ,data_scale as 缺省值,
          data_scale as 备注

         

        
      
        
from user_tab_columns t

group by TABLE_NAME
          ,column_id,
          column_name,
          data_type,
          data_length,
          data_precision,
          data_scale,
          nullable