Conversion Sql to Oracle

USE [S3G_Dev_Ver_1.0]

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

ALTER TRIGGER [dbo].[Customer_Table_Audit_Trigger]

ON [dbo].[S3G_ORG_CustomerMaster]

For update,DELETE

AS

if exists(select 'x' from S3G_SYSAD_GlobalParameterSetup where Is_Audit=1)

Declare @Ins nvarchar(max)

Declare @Upd nvarchar(max)

Declare @Company_ID INT

Declare @Program_ID INT

Declare @Location_Code Varchar(30)

Declare @User_ID INT

Declare @Table_Name Varchar(200)

Declare @LookUp_Text Varchar(300)

--select * from inserted

--select * from deleted

set @Ins=(select * from inserted for xml auto, ROOT('Root'))

set @Upd = (Select * from Deleted for XML Auto, ROOT('Root'))

if(@Ins is not null)

begin

Select @Company_ID=1,@User_ID=(select isnull(Modified_by,0) from Inserted)

select @Table_Name= obj.name from sys.triggers trig

inner join sysobjects obj on trig.parent_id=obj.id where trig.object_id=@@procid

select @Program_ID= Program_ID from S3G_AT_Lookup_Hdr where SRC_Table_name=@Table_Name

Exec S3G_Ins_Audit_Trail @XML_Inserted=@Ins,@XML_Deleted=@Upd,@Table_Name=@Table_Name,@Company_ID=@Company_ID,@Program_ID=@Program_ID,@Location_Code=@Location_Code,@User_ID=@User_ID

end

end