一、遇到问题:需要取得新建表的表结构导入到文本
通过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