询问一句SQL Server中的sql语句,如何转成Oracle能用
本句在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