Oracle内置数据类型可以分为:字符数据类型、数值类型、long与raw类型、时间日期类型、大对象、rowid六种。请带我学习这六种数据类型的大类,搭建oracle数据库进行学习和研究,写脚本。非常感谢。
1. 字符数据类型:
1.1
定长:CHAR、NCHAR
变长:VARCHAR2、NVARCHAR2
1.2 NCHAR[(size)]
1.3 VARCHAR2(size [BYTE | CHAR])
1.4 NVARCHAR2(size)
2. 数值类型
2.1 NUMBER [ (p [, s]) ]
2.2 FLOAT [(p)]
2.3 BINARY_FLOAT和BINARY_DOUBLE
3. long与raw类型
3.1 Long;
3.2 RAW(size)和LONG RAW
4. 时间日期类型:
4.1 DATE
4.2 TIMESTAMP[(fractional_seconds_precision)]
4.3 TIMESTAMP[(fractional_seconds_precision)] WITH TIME ZONE
4.4 TIMESTAMP[(fractional_seconds_precision)]
4.5 INTERVAL YEAR [(year_precision)] TO MONTH
5.6 INTERVAL DAY [(day_precision)] TO SECOND[(fractional_seconds_precision)]
5. 大对象
5.1 BLOB
5.2 CLOB
5.3 NCLOB
5.4 BFILE
6. ROWID
6.1 ROWID
6.2 UROWID

1. 字符数据类型:
1.1
定长:CHAR、NCHAR
变长:VARCHAR2、NVARCHAR2
1.2 NCHAR[(size)]
1.3 VARCHAR2(size [BYTE | CHAR])
1.4 NVARCHAR2(size)
2. 数值类型
2.1 NUMBER [ (p [, s]) ]
2.2 FLOAT [(p)]
2.3 BINARY_FLOAT和BINARY_DOUBLE
3. long与raw类型
3.1 Long;
3.2 RAW(size)和LONG RAW
4. 时间日期类型:
4.1 DATE
4.2 TIMESTAMP[(fractional_seconds_precision)]
4.3 TIMESTAMP[(fractional_seconds_precision)] WITH TIME ZONE
4.4 TIMESTAMP[(fractional_seconds_precision)]
4.5 INTERVAL YEAR [(year_precision)] TO MONTH
5.6 INTERVAL DAY [(day_precision)] TO SECOND[(fractional_seconds_precision)]
5. 大对象
5.1 BLOB
5.2 CLOB
5.3 NCLOB
5.4 BFILE
6. ROWID
6.1 ROWID
6.2 UROWID