alguém conhece algum site ou alguma maneira para eu poder converter essa trigger para o oracle, eu não entendo praticamente nada de trigger.
CREATE TRIGGER TRG_INC_TGFLIV_AOL_AJDSIMP ON TGFLIV
FOR INSERT
AS
BEGIN
DECLARE
@AD_OBS_VLRST FLOAT,
@AD_OBS_BASEST FLOAT,
@NUNOTA INT,
@ORIGEM VARCHAR(1),
@SEQUENCIA INT,
@CODEMP INT,
@CODTRIB INT,
@ENTSAI VARCHAR(1)
SELECT @NUNOTA =NUNOTA ,
@ORIGEM =ORIGEM ,
@SEQUENCIA =SEQUENCIA ,
@CODEMP =CODEMP,
@CODTRIB =CODTRIB,
@ENTSAI=ENTSAI
FROM inserted
IF (SELECT COUNT(*) FROM TGFCAB,TGFPAR WHERE TGFCAB.CODPARC=TGFPAR.CODPARC AND TGFPAR.SIMPLES='S' )=0
BEGIN
RETURN
END
ELSE
BEGIN
IF @ENTSAI='E' AND (SELECT VALOR FROM TGFDIN WHERE NUNOTA=@NUNOTA AND SEQUENCIA=@SEQUENCIA AND CODIMP=1)>0
BEGIN
INSERT INTO TGFAJD
(NUNOTA, ORIGEM, SEQUENCIA, CODEMP, CODOBSPADRAO, CODAJUSTE, COMPOBSPADRAO, COMPAJUSTE, BASEICMS, ALIQICMS, VLRICMS, VLROUTROS, CODUSU, DHALTER, AGRUPAR, BCICMSSTANT) VALUES
(@NUNOTA,@ORIGEM,@SEQUENCIA,@CODEMP,18 , 10990505 , ' ' , ' ' , 0 , 0 ,(SELECT VALOR FROM TGFDIN WHERE NUNOTA=@NUNOTA AND SEQUENCIA=@SEQUENCIA AND CODIMP=1),0 ,0 ,GETDATE(),'N' ,0)
END
END
END
GO