关于mysql的创建视图的语句转换成oracle里面创建视图的语句

[洗洗就敲代码]

哪位大神能帮我把下面的mysql数据库里面建视图的语句修改成在oracle中能达到同样效果的语句啊？
DROP VIEW IF EXISTS `v_equipment_info`;
CREATE VIEW `v_equipment_info` AS
select `a`.`deviceID` AS `deviceID`,`a`.`stationNO` AS `stationNO`,`a`.`stationName` AS `stationName`,`b`.`zoneID` AS `zoneID`,`b`.`zoneName` AS `zoneName`,`c`.`deviceTypeID` AS `deviceTypeID`,`c`.`typeName` AS `typeName`,`d`.`statusName` AS `statusName`,`d`.`isNormal` AS `isNormal`,`a`.`deviceNowStatus` AS `deviceNowStatus`,`a`.`inspectionStatus` AS `InspectionStatus`,`b`.`responsePersonID` AS `responsePersonID`,`user3`.`user_name` AS `responsePersonName`,`a`.`inspectionPersonID` AS `inspectionPersonID`,`user1`.`user_name` AS `inspectorPersonName`,`a`.`repairPersonID` AS `repairPersonID`,`user2`.`user_name` AS `repairPersonName` from ((((((`new_inspection`.`devicebaseinfo` `a` join `new_inspection`.`zonelocation` `b`) join `new_inspection`.`devicetype` `c`) join `new_inspection`.`devicestatus` `d`) left join `new_inspection`.`userinfo` `user1` on(((`a`.`inspectionPersonID` = `user1`.`person_id`) and (`user1`.`deleteFlag` <> -(1))))) left join `new_inspection`.`userinfo` `user2` on(((`a`.`repairPersonID` = `user2`.`person_id`) and (`user2`.`deleteFlag` <> -(1))))) left join `new_inspection`.`userinfo` `user3` on(((`b`.`responsePersonID` = `user3`.`person_id`) and (`user3`.`deleteFlag` <> -(1))))) where ((`a`.`zoneID` = `b`.`zoneID`) and (`c`.`deviceTypeID` = `a`.`deviceTypeID`) and (`a`.`deviceNowStatus` = `d`.`statusID`) and (`a`.`deleteFlag` <> -(1)));

多谢了！！！

[一颗向往数据的心丶]

oracle创建视图前删除视图可以用

create or replace view v_equipment_info as ...

还有就是你的各种链接(join)查询的时候oracle要详细注明select语句的。 希望你自己详细调整下，我们无表不好数据查询测试、

[洗洗就敲代码]

引用 1 楼 z_shousi 的回复:

oracle创建视图前删除视图可以用

create or replace view v_equipment_info as ...

还有就是你的各种链接(join)查询的时候oracle要详细注明select语句的。 希望你自己详细调整下，我们无表不好数据查询测试、

。。。。。。。。。。。这些都知道啊，我就是想知道转换逻辑啊，因为涉及到left join