通過navicat匯出的mysql資料庫的腳本如下，怎么轉換成ORACLE資料庫的建表陳述句，以在oracle中建一個相同的表
DROP TABLE IF EXISTS `monitor`;
CREATE TABLE `monitor` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`iris_id` varchar(10) DEFAULT NULL,
`measure_time` datetime DEFAULT NULL,
`measure_type` int(11) DEFAULT NULL,
`measure_cycles` int(11) DEFAULT NULL,
`measure_sensitivity` int(11) DEFAULT NULL,
`cycle_shift` int(11) DEFAULT NULL,
`measure_status` int(11) DEFAULT NULL,
`measure_quality` int(11) DEFAULT NULL,
`phase_name` varchar(45) DEFAULT NULL,
`phase_channel` varchar(45) DEFAULT NULL,
`nqn_c1_plus` float DEFAULT NULL,
`nqn_c1_minus` float DEFAULT NULL,
`qm_cl_plus` float DEFAULT NULL,
`qm_cl_minus` float DEFAULT NULL,
`nqn_c2_plus` float DEFAULT NULL,
`nqn_c2_minus` float DEFAULT NULL,
`qm_c2_plus` int(11) DEFAULT NULL,
`qm_c2_minus` float DEFAULT NULL,
`c1p1` float DEFAULT NULL,
`c1p2` float DEFAULT NULL,
`c1p3` float DEFAULT NULL,
`c1p4` float DEFAULT NULL,
`c1p5` float DEFAULT NULL,
`c1p6` float DEFAULT NULL,
`c1p7` float DEFAULT NULL,
`c1p8` float DEFAULT NULL,
`c1p9` float DEFAULT NULL,
`c1p10` float DEFAULT NULL,
`c1p11` float DEFAULT NULL,
`c1p12` float DEFAULT NULL,
`c1p13` float DEFAULT NULL,
`c1p14` float DEFAULT NULL,
`c1p15` float DEFAULT NULL,
`c1p16` float DEFAULT NULL,
`c1m1` float DEFAULT NULL,
`c1m2` float DEFAULT NULL,
`c1m3` float DEFAULT NULL,
`c1m4` float DEFAULT NULL,
`c1m5` float DEFAULT NULL,
`c1m6` float DEFAULT NULL,
`c1m7` float DEFAULT NULL,
`c1m8` float DEFAULT NULL,
`c1m9` float DEFAULT NULL,
`c1m10` float DEFAULT NULL,
`c1m11` float DEFAULT NULL,
`c1m12` float DEFAULT NULL,
`c1m13` float DEFAULT NULL,
`c1m14` float DEFAULT NULL,
`c1m15` float DEFAULT NULL,
`c1m16` float DEFAULT NULL,
`c2p1` float DEFAULT NULL,
`c2p2` float DEFAULT NULL,
`c2p3` float DEFAULT NULL,
`c2p4` float DEFAULT NULL,
`c2p5` float DEFAULT NULL,
`c2p6` float DEFAULT NULL,
`c2p7` float DEFAULT NULL,
`c2p8` float DEFAULT NULL,
`c2p9` float DEFAULT NULL,
`c2p10` float DEFAULT NULL,
`c2p11` float DEFAULT NULL,
`c2p12` float DEFAULT NULL,
`c2p13` float DEFAULT NULL,
`c2p14` float DEFAULT NULL,
`c2p15` float DEFAULT NULL,
`c2p16` float DEFAULT NULL,
`c2m1` float DEFAULT NULL,
`c2m2` float DEFAULT NULL,
`c2m3` float DEFAULT NULL,
`c2m4` float DEFAULT NULL,
`c2m5` float DEFAULT NULL,
`c2m6` float DEFAULT NULL,
`c2m7` float DEFAULT NULL,
`c2m8` float DEFAULT NULL,
`c2m9` float DEFAULT NULL,
`c2m10` float DEFAULT NULL,
`c2m11` float DEFAULT NULL,
`c2m12` float DEFAULT NULL,
`c2m13` float DEFAULT NULL,
`c2m14` float DEFAULT NULL,
`c2m15` float DEFAULT NULL,
`c2m16` float DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=502653 DEFAULT CHARSET=utf8;
uj5u.com熱心網友回復：
CREATE TABLE MONITOR
( id NUMBER(20,0) NOT NULL ENABLE,
iris_id NVARCHAR2(10),
measure_time DATE,
measure_type NUMBER(11,0),
measure_cycles NUMBER(11,0),
measure_sensitivity NUMBER(11,0),
cycle_shift NUMBER(11,0),
measure_status NUMBER(11,0),
measure_quality NUMBER(11,0),
phase_name NVARCHAR2(45),
phase_channel NVARCHAR2(45),
nqn_c1_plus NUMBER,
nqn_c1_minus NUMBER,
qm_cl_plus NUMBER,
qm_cl_minus NUMBER,
nqn_c2_plus NUMBER,
nqn_c2_minus NUMBER,
qm_c2_plus NUMBER(11,0),
qm_c2_minus NUMBER,
c1p1 NUMBER,
c1p2 NUMBER,
c1p3 NUMBER,
c1p4 NUMBER,
c1p5 NUMBER,
c1p6 NUMBER,
c1p7 NUMBER,
c1p8 NUMBER,
c1p9 NUMBER,
c1p10 NUMBER,
c1p11 NUMBER,
c1p12 NUMBER,
c1p13 NUMBER,
c1p14 NUMBER,
c1p15 NUMBER,
c1p16 NUMBER,
c1m1 NUMBER,
c1m2 NUMBER,
c1m3 NUMBER,
c1m4 NUMBER,
c1m5 NUMBER,
c1m6 NUMBER,
c1m7 NUMBER,
c1m8 NUMBER,
c1m9 NUMBER,
c1m10 NUMBER,
c1m11 NUMBER,
c1m12 NUMBER,
c1m13 NUMBER,
c1m14 NUMBER,
c1m15 NUMBER,
c1m16 NUMBER,
c2p1 NUMBER,
c2p2 NUMBER,
c2p3 NUMBER,
c2p4 NUMBER,
c2p5 NUMBER,
c2p6 NUMBER,
c2p7 NUMBER,
c2p8 NUMBER,
c2p9 NUMBER,
c2p10 NUMBER,
c2p11 NUMBER,
c2p12 NUMBER,
c2p13 NUMBER,
c2p14 NUMBER,
c2p15 NUMBER,
c2p16 NUMBER,
c2m1 NUMBER,
c2m2 NUMBER,
c2m3 NUMBER,
c2m4 NUMBER,
c2m5 NUMBER,
c2m6 NUMBER,
c2m7 NUMBER,
c2m8 NUMBER,
c2m9 NUMBER,
c2m10 NUMBER,
c2m11 NUMBER,
c2m12 NUMBER,
c2m13 NUMBER,
c2m14 NUMBER,
c2m15 NUMBER,
c2m16 NUMBER,
PRIMARY KEY (id)
);
uj5u.com熱心網友回復：
NVARCHAR2 改為varchar2吧，忘記改了。uj5u.com熱心網友回復：
謝謝，我明天去試一下！uj5u.com熱心網友回復：
用getways 建資料連接，后面 直接 create table tt as （select * from t1@資料庫連接 where 1=0）
自己就能轉了
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/73383.html
標籤：開發
上一篇：在線急等