相关链接
1 静态数据字典
┄┄┄原文
┄┄┄这类数据字典主要是由表和视图组成。应该注意的是,数据字典中的表是不能直接来访问的,但是可以访问数据字典中的视图。静态数据字典中的视图分为三类,它们分别为:DBA_、ALL_、USER_。
DBA_TAB_COMMENTS
displays comments on all tables and views in the database. Its columns are the same as those in ALL_TAB_COMMENTS.
在数据库中的所有表和视图上显示注释。
表结构与"ALL_TAB_COMMENTS"一致。ALL_TAB_COMMENTS
displays comments on the tables and views accessible to the current user.
在当前用户可访问的表和视图上显示注释。USER_TAB_COMMENTS
displays comments on the tables and views owned by the current user. Its columns (except for OWNER) are the same as those in ALL_TAB_COMMENTS.
在当前用户拥有的表和视图上显示注释。此视图不显示OWNER字段。
2 ALL_TAB_COLUMNS 数据字典
DBA_TAB_COMMENTS
,ALL_TAB_COMMENTS
表结构完全一致 ,USER_TAB_COMMENTS
没有OWNER字段。
Ser | Column | DataType | Null | Description |
---|---|---|---|---|
1 | OWNER 库 | VARCHAR2(30) | NOT NULL | Owner of the table, view, or cluster 表、视图或集群的拥有者 |
2 | TABLE_NAME 表名 | VARCHAR2(30) | NOT NULL | Name of the table, view, or cluster 表、视图或集群的名称 |
3 | COLUMN_NAME 字段名 | VARCHAR2(30) | NOT NULL | Column name 列名 |
4 | DATA_TYPE 字段类型 | VARCHAR2(106) | Datatype of the column 列的数据类型 | |
5 | DATA_TYPE_MOD ??? | VARCHAR2(3) | Datatype modifier of the column 列的数据类型修饰符? | |
6 | DATA_TYPE_OWNER ???(库名) | VARCHAR2(30) | Owner of the datatype of the column 列的数据类型的所有者 | |
7 | DATA_LENGTH 长度 | NUMBER | NOT NULL | Length of the column (in bytes) 列长度(以字节为单位) |
8 | DATA_PRECISION 精度 | NUMBER | Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes 数字数据类型的十进制精度;浮点数据类型的二进制精度;其他数据类型为空 | |
9 | DATA_SCALE 标度 | NUMBER | Digits to the right of the decimal point in a number 一个数中小数点右边的数字 | |
10 | NULLABLE 允许为空 | VARCHAR2(1) | Indicates whether a column allows NULLs. The value is N if there is a NOT NULL constraint on the column or if the column is part of a PRIMARY KEY. The constraint should be in an ENABLE VALIDATE state. 指示列是否允许空值。如果列上存在NOT NULL约束,或者列是主键的一部分,则值为N。约束应该处于启用验证状态。 | |
11 | COLUMN_ID 字段序号 | NUMBER | Sequence number of the column as created 创建的列的序列号 | |
12 | DEFAULT_LENGTH 默认值字节数 | NUMBER | Length of the default value for the column 列的默认值的长度(字节数) | |
13 | DATA_DEFAULT 默认值 | LONG | Default value for the column 列的默认值 例如:“ZT” NUMBER DEFAULT 0 | |
14 | NUM_DISTINCT 列去重后数量 | NUMBER | Number of distinct values in the columnFoot 1 列中不同值的数目 | |
15 | LOW_VALUE 低位 | RAW(32) | Low value in the column Footref 1 列中的最小值 | |
16 | HIGH_VALUE 高位 | RAW(32) | High value in the columnFootref 1 列中的最大值 | |
17 | DENSITY 密度 | NUMBER | Density of the columnFootref 1 列密度∈[0,1] | |
18 | NUM_NULLS NULL值数量 | NUMBER | Number of NULLs in the column 列中的NULL值数量 | |
19 | NUM_BUCKETS 桶数 | NUMBER | Number of buckets in the histogram for the column Note: The number of buckets in a histogram is specified in the SIZE parameter of the ANALYZE SQL statement. However, Oracle Database does not create a histogram with more buckets than the number of rows in the sample. Also, if the sample contains any values that are very repetitious, Oracle Database creates the specified number of buckets, but the value indicated by this column may be smaller because of an internal compression algorithm.列的(统计)直方图中的桶数 注解:直方图中的桶数是在ANALYZE SQL语句的SIZE参数中指定的。但是,Oracle数据库不会创建一个桶数多于样例中行数的柱状图。另外,如果示例中包含重复非常多的值,Oracle数据库将创建指定数量的桶,但是由于使用了内部压缩算法,此列所指示的值可能会更小。 | |
20 | LAST_ANALYZED 最近ANALYZE日期 | DATE | Date on which this column was most recently analyzed 列最近被分析的日期 | |
21 | SAMPLE_SIZE 样本大小 | NUMBER | Sample size used in analyzing this column 用于分析这一列的样本大小 | |
22 | CHARACTER_SET_NAME 字符集名称 | VARCHAR2(44) | Name of the character set: 字符集名称 ● CHAR_CS ● NCHAR_CS | |
23 | CHAR_COL_DECL_LENGTH 字符类型列的声明长度 | NUMBER | Declaration length of the character type column 字符类型列的声明长度 | |
24 | GLOBAL_STATS 全球状态 | VARCHAR2(3) | For partitioned tables, indicates whether column statistics were collected for the table as a whole (YES ) or were estimated from statistics on underlying partitions and subpartitions (NO )对于分区表,指示是从整体上收集表的列统计信息(YES),还是从基础分区和子分区的统计信息中估计的(NO) | |
25 | USER_STATS 用户状态 | VARCHAR2(3) | Indicates whether statistics were entered directly by the user (YES ) or not (NO )指示统计信息是否由用户直接输入(YES)或否(NO) | |
26 | AVG_COL_LEN 列的平均字节长度 | NUMBER | Average length of the column (in bytes) 列的平均长度(以字节为单位) | |
27 | CHAR_LENGTH 字符类型长度 | NUMBER | Displays the length of the column in characters. This value only applies to the following datatypes: 以字符显示列的长度。此值仅适用于以下数据类型: ● CHAR ● VARCHAR2 ● NCHAR ● NVARCHAR | |
28 | CHAR_USED 字符类型使用(的定义语言) | NUMBER | Indicates that the column uses BYTE length semantics (B) or CHAR length semantics ©, or whether the datatype is not any of the following (NULL): 指示列使用字节长度语义(B)或字符长度语义©,或者数据类型是否不属于下列任何一种(NULL): ● CHAR ● VARCHAR2 ● NCHAR ● NVARCHAR2 | |
29 | V80_FMT_IMAGE V80 图像格式 | NUMBER | Indicates whether the column data is in release 8.0 image format (YES ) or not (NO )指示列数据是否采用release 8.0图像格式(YES)或not (NO) | |
30 | DATA_UPGRADED 数据升级 | NUMBER | Indicates whether the column data has been upgraded to the latest type version format (YES ) or not (NO )指示列数据是否已升级为最新类型版本格式(YES)或未(NO) | |
31 | HISTOGRAM (统计)直方图 | NUMBER | Indicates existence/type of histogram: 表示直方图的存在/类型: ● NONE ● FREQUENCY ● HEIGHT BALANCED |
20/12/04
M