user_tab_columns 表相关及排序问题

一、遇到问题：需要取得新建表的表结构导入到文本

通过select * from user_tab_columns t where t.table_name = 'XX' (说明：XX为要找的表)得到表结构，但是有些表结构与新建的表字段顺序不一致（也就是用途VIEW查看表结构时的属性，如原表是A(NF,XB_DM,XB_MC,SJLY_DM),通过上面的SQL语句输出的A表结构是A(SJLY_DN,NF,XB_DM,XB_MC)）。通过网上查找，只要添加order by column_id asc 即可与原表保持一致。

select * from user_tab_columns t where t.table_name = 'XX' order by column_id asc;

新问题：怎样查oracle自带视图中字段代表的意义？(要加班了，回去再查)

二、user_tab_colunms 介绍

http://www.ss64.com/orad/USER_TAB_COLUMNS.html

USER_TAB_COLUMNS

Columns of user's tables, views and clusters专栏的用户的表，视图和集群

 Columns专栏 
    ___________________________ ___________________________ 
 
    TABLE_NAME TABLE_NAME 
       Table,view or cluster name表，视图或群集名称 
    COLUMN_NAME COLUMN_NAME 
       Column name列名 
    DATA_TYPE DATA_TYPE 
       Datatype of the column数据类型的列 
    DATA_TYPE_MOD DATA_TYPE_MOD 
       Datatype modifier of the column数据类型修饰符的栏 
    DATA_TYPE_OWNER DATA_TYPE_OWNER 
       Owner of the datatype of the column所有者数据类型的列 
    DATA_LENGTH DATA_LENGTH 
       Length of the column in bytes长度栏字节 
    DATA_PRECISION DATA_PRECISION 
       Length: decimal digits (NUMBER) or binary digits (FLOAT)长度：小数（号码）或二进制数字（浮法） 
    DATA_SCALE DATA_SCALE 
       Digits to right of decimal point in a number位数权利小数点在一些 
    NULLABLE空 
       Does column allow NULL values?是否允许NULL值的列？ 
    COLUMN_ID COLUMN_ID 
       Sequence number of the column as created序号栏的创建 
    DEFAULT_LENGTH DEFAULT_LENGTH 
       Length of default value for the column长度的默认值为柱 
    DATA_DEFAULT DATA_DEFAULT 
       Default value for the column默认值为柱 
    NUM_DISTINCT NUM_DISTINCT 
       The number of distinct values in the column一些独特的价值观念中的栏 
    LOW_VALUE LOW_VALUE 
       The low value in the column价值低栏 
    HIGH_VALUE HIGH_VALUE 
       The high value in the column高价值的栏 
    DENSITY密度 
       The density of the column密度柱 
    NUM_NULLS NUM_NULLS 
       The number of nulls in the column空值的数量在列 
    NUM_BUCKETS NUM_BUCKETS 
       The number of buckets in histogram for the column水桶的数量在直方图栏 
    LAST_ANALYZED LAST_ANALYZED 
       The date of the most recent time this column was analyzed日期最近的时间，分析了此列 
    SAMPLE_SIZE SAMPLE_SIZE 
       The sample size used in analyzing this column样本大小分析中使用此栏 
    CHARACTER_SET_NAME CHARACTER_SET_NAME 
       Character set name字符集名称 
    CHAR_COL_DECL_LENGTH CHAR_COL_DECL_LENGTH 
       Declaration length of character type column宣言长度字符类型列 
    GLOBAL_STATS GLOBAL_STATS 
       Are the statistics calculated without merging underlying partitions?有统计数据计算，合并基本分区？ 
    USER_STATS USER_STATS 
       Were the statistics entered directly by the user?有统计数据直接输入的用户？ 
    AVG_COL_LEN AVG_COL_LEN 
       The average length of the column in bytes的平均长度为字节栏 
    CHAR_LENGTH CHAR_LENGTH 
       The maximum length of the column in characters最大长度的列中的字符 
    CHAR_USED CHAR_USED 
       C is maximum length given in characters,B if in bytes C是最大长度给予字符，如果在乙字节 
    V80_FMT_IMAGE V80_FMT_IMAGE 
       Is column data in 8.0 image format?一列中的数据8.0图像格式？ 
    DATA_UPGRADED DATA_UPGRADED 
       Has column data been upgraded to the latest type version format?列数据已被升级到最新型的版本格式？ 

Related: 相关：

 DBA_ALL_TABLES ALL_ALL_TABLES  USER_ALL_TABLES DBA_ALL_TABLES ALL_ALL_TABLES USER_ALL_TABLES 
  DBA_PART_TABLES  ALL_PART_TABLES USER_PART_TABLES DBA_PART_TABLES ALL_PART_TABLES USER_PART_TABLES  
  DBA_TABLES   ALL_TABLES  USER_TABLES TAB DBA_TABLES ALL_TABLES USER_TABLES TAB键  
  DBA_TAB_COLUMNS ALL_TAB_COLUMNS        USER_TAB_COLUMNS DBA_TAB_COLUMNS ALL_TAB_COLUMNS USER_TAB_COLUMNS  
  DBA_TAB_COLS   ALL_TAB_COLS  USER_TAB_COLS DBA_TAB_COLS ALL_TAB_COLS USER_TAB_COLS  
  DBA_TAB_COL_STATISTICS ALL_TAB_COL_STATISTICS USER_TAB_COL_STATISTICS DBA_TAB_COL_STATISTICS ALL_TAB_COL_STATISTICS USER_TAB_COL_STATISTICS  
  DBA_TAB_COMMENTS   ALL_TAB_COMMENTS  USER_TAB_COMMENTS DBA_TAB_COMMENTS ALL_TAB_COMMENTS USER_TAB_COMMENTS  
  DBA_TAB_HISTOGRAMS   ALL_TAB_HISTOGRAMS  USER_TAB_HISTOGRAMS DBA_TAB_HISTOGRAMS ALL_TAB_HISTOGRAMS USER_TAB_HISTOGRAMS  
  DBA_TAB_MODIFICATIONS ALL_TAB_MODIFICATIONS USER_TAB_MODIFICATIONS DBA_TAB_MODIFICATIONS ALL_TAB_MODIFICATIONS USER_TAB_MODIFICATIONS  
  DBA_TAB_PARTITIONS   ALL_TAB_PARTITIONS USER_TAB_PARTITIONS DBA_TAB_PARTITIONS ALL_TAB_PARTITIONS USER_TAB_PARTITIONS