Oracle转EDB总结

数据类型

character datatypes

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

### number datatypes

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

### long and raw datatypes

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

### datetime datatypes

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

### large object datatypes

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

### rowid datatypes

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

### ANSI supported datatypes

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

### any types

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

### XML types

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

### spatial types

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

### media types

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

Other datatypes

## 方法

Oracle数据类型		EDB数据类型
CHAR [(size [BYTE | CHAR]) ]	CHAR	CHAR
	CHAR(size [BYTE | CHAR])	CHAR(size)
VARCHAR2 [(size [BYTE | CHAR]) ]	VARCHAR2	VARCHAR2
	VARCHAR2(size [BYTE | CHAR])	VARCHAR2(size)
NCHAR [ (size) ]	NCHAR	CHAR
	NCHAR(size)	CHAR(size)
NVARCHAR2 (size)	NVARCHAR2(size)	VARCHAR(size)

## DDL

FUNCTION

### MATERIALIZED VIEW #### CREATE - 物理属性、字段属性等无关信息去掉

ALTER

• 物理属性、字段属性等无关信息去掉

DROP

• 物理属性、字段属性等无关信息去掉

### TABLE CREATE - 物理属性、字段属性等无关信息去掉

ALTER

• 物理属性、字段属性等无关信息去掉

DROP

• 物理属性、字段属性等无关信息去掉

TYPE

TYPE BODY

PROCEDURE

TRIGGER

VIEW

CREATE

• 物理属性、字段属性等无关信息去掉

ALTER

DROP

## DML ### SELECT

INSERT

DELETE

UPDATE

---

参考

• http://www.sqlines.com/oracle-to-postgresql
• Oracle官网文档
• EDB官网文档

赏