求大神帮我翻译一下
求大神帮我翻译成 oracle 的触发器 很急。。。。
create or replace trigger DATA10TH
before insert on DATA10TH
for each row
/*定义变量*/
declare @RFID NVARCHAR2(2000)
declare @LNG NUMBER(18,2)
declare @LAT NUMBER(18,2)
declare @JZ_ID NVARCHAR2(150)
declare @UPLOADID NVARCHAR2(100)
declare @CREATEDATE DATE
select @JZ_ID=JZ_ID,@RFID=RFID,@UPLOADID=UPLOADID,@CREATEDATE=CREATEDATE
from inserted--查询当前插入的信息
if exists(select*from JZ where JZ_ID=@JZ_ID )
begin
----如果存在,就更新记录
select @LNG=LNG,@LAT=LAT, from JZ where JZ_ID=@JZ_ID --根据编号查询基站信息
update DATA10TH set LNG=@LNG,LAT=@LAT where UPLOADID=@UPLOADID--更新当前插入的信息
update CAR_MESSAGE set LNG=@LNG,LAT=@LAT ,CREATEDATE=@CREATEDATE, JZ_ID=@JZ_ID where charindex(RFID,@RFID,0) > 0
update JZ set CREATEDATE=@CREATEDATE where JZ_ID=@JZ_ID--更新当前插入的信息
end DATA10TH;