Repository navigation
Expand file tree
/
Copy pathoracle_map.go
More file actions
124 lines (120 loc) · 3.52 KB
/
Copy pathoracle_map.go
File metadata and controls
124 lines (120 loc) · 3.52 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
package oracle
// Data type conversion maps from Oracle to other database types
var (
// OracleToMySQL Data type conversions from Oracle to MySQL
OracleToMySQL = map[string]string{
"NUMBER": "decimal",
"NUMBER(1)": "boolean",
"NUMBER(3)": "tinyint",
"NUMBER(5)": "smallint",
"NUMBER(10)": "int",
"NUMBER(19)": "bigint",
"BINARY_FLOAT": "float",
"BINARY_DOUBLE": "double",
"FLOAT": "double",
"CHAR": "char",
"NCHAR": "char",
"VARCHAR2": "varchar",
"NVARCHAR2": "varchar",
"CLOB": "text",
"NCLOB": "text",
"LONG": "text",
"BLOB": "longblob",
"RAW": "binary",
"LONG RAW": "longblob",
"DATE": "datetime",
"TIMESTAMP": "datetime",
"INTERVAL YEAR": "varchar(100)",
"INTERVAL DAY": "varchar(100)",
"XMLTYPE": "text",
"ROWID": "char(18)",
"UROWID": "varchar(4000)",
}
// OracleToPostgreSQL Data type conversions from Oracle to PostgreSQL
OracleToPostgreSQL = map[string]string{
"NUMBER": "numeric",
"NUMBER(1)": "boolean",
"NUMBER(3)": "smallint",
"NUMBER(5)": "smallint",
"NUMBER(10)": "integer",
"NUMBER(19)": "bigint",
"BINARY_FLOAT": "real",
"BINARY_DOUBLE": "double precision",
"FLOAT": "double precision",
"CHAR": "char",
"NCHAR": "char",
"VARCHAR2": "varchar",
"NVARCHAR2": "varchar",
"CLOB": "text",
"NCLOB": "text",
"LONG": "text",
"BLOB": "bytea",
"RAW": "bytea",
"LONG RAW": "bytea",
"DATE": "timestamp",
"TIMESTAMP": "timestamp",
"INTERVAL YEAR": "interval",
"INTERVAL DAY": "interval",
"XMLTYPE": "xml",
"ROWID": "char(18)",
"UROWID": "varchar(4000)",
}
// OracleToSQLServer Data type conversions from Oracle to SQL Server
OracleToSQLServer = map[string]string{
"NUMBER": "decimal",
"NUMBER(1)": "bit",
"NUMBER(3)": "tinyint",
"NUMBER(5)": "smallint",
"NUMBER(10)": "int",
"NUMBER(19)": "bigint",
"BINARY_FLOAT": "real",
"BINARY_DOUBLE": "float",
"FLOAT": "float",
"CHAR": "char",
"NCHAR": "nchar",
"VARCHAR2": "varchar",
"NVARCHAR2": "nvarchar",
"CLOB": "varchar(max)",
"NCLOB": "nvarchar(max)",
"LONG": "varchar(max)",
"BLOB": "varbinary(max)",
"RAW": "varbinary",
"LONG RAW": "varbinary(max)",
"DATE": "datetime2",
"TIMESTAMP": "datetime2",
"INTERVAL YEAR": "varchar(100)",
"INTERVAL DAY": "varchar(100)",
"XMLTYPE": "xml",
"ROWID": "char(18)",
"UROWID": "varchar(4000)",
}
// OracleToSQLite Data type conversions from Oracle to SQLite
OracleToSQLite = map[string]string{
"NUMBER": "REAL",
"NUMBER(1)": "INTEGER",
"NUMBER(3)": "INTEGER",
"NUMBER(5)": "INTEGER",
"NUMBER(10)": "INTEGER",
"NUMBER(19)": "INTEGER",
"BINARY_FLOAT": "REAL",
"BINARY_DOUBLE": "REAL",
"FLOAT": "REAL",
"CHAR": "TEXT",
"NCHAR": "TEXT",
"VARCHAR2": "TEXT",
"NVARCHAR2": "TEXT",
"CLOB": "TEXT",
"NCLOB": "TEXT",
"LONG": "TEXT",
"BLOB": "BLOB",
"RAW": "BLOB",
"LONG RAW": "BLOB",
"DATE": "TEXT",
"TIMESTAMP": "TEXT",
"INTERVAL YEAR": "TEXT",
"INTERVAL DAY": "TEXT",
"XMLTYPE": "TEXT",
"ROWID": "TEXT",
"UROWID": "TEXT",
}
)