询问一句SQL Server中的sql语句，如何转成Oracle能用

[peppers]

本句在SQL Server中运行完全正常
select a.cVID, a.cPlateType+a.cPlateID as cPlate, a.dtVtime, d.cVehicleType, b.cVloc,
d.cVehicleType, c.cVaction, a.iImageID, a.iPlateStamp, a.cDocID, a.iFine, a.iLateFee,
(a.iFine+a.iLateFee) as iTotalFee, f.date_limited, g.cFileName, a.cBatchNum
from ( select cVID, cPlateType, cPlateID, dtVtime, cVTypeID, cRoadID,cVactionID, iImageID,
iPlateStamp, cDocID, iFine, iLateFee, cBatchNum from violation_record ) a, ( select cRoadID, cVloc from road_info ) b,
( select cVactionID, cVaction from violation_actions ) c,
( select cVTypeID, cVehicleType from vehicle_type_info ) d,
( select cPlateType, iOwnerType from licence_type_info ) e,
( select cParamValue as date_limited from sys_parameter where ID=107 ) f,
( select iImageID, cFileName from image_info) g
where dtVtime>='2003-10-15 00:00:00' and dtVtime<='2003-10-16 23:59:59' and
a.cVTypeID=d.cVTypeID and a.cPlateType=e.cPlateType and a.cRoadID=b.cRoadID and
a.cVactionID=c.cVactionID and a.iPlateStamp=g.iImageID

[beckhambobo]

where dtVtime>='2003-10-15 00:00:00' and dtVtime<='2003-10-16 23:59:59'
修改为:
where dtVtime>=to_date('2003-10-15 00:00:00','yyyy-mm-dd hh24:mi:ss') and dtVtime<=to_date('2003-10-16 23:59:59','yyyy-mm-dd hh24:mi:ss')

[oklida]

第一行的 a.cPlateType+a.cPlateID as cPlate 编译也有错误啊

[beckhambobo]

报什么错？

[cmaboy]

如果他们字符型数据，那么改为
a.cPlateType||a.cPlateID

[beckhambobo]

oracle会隐式转换