请教mysql建表语句转oracle语句

scmswwj 2018-01-30 03:44:14

通过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;

...全文

1354 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

学海无涯-回头是岸 2018-02-01

打赏
举报

用getways 建数据连接，后面直接 create table tt as （select * from t1@数据库连接 where 1=0）自己就能转了

scmswwj 2018-01-30

打赏
举报

谢谢，我明天去试一下！

liu志坚 2018-01-30

打赏
举报

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) );

liu志坚 2018-01-30