-
sql trigger to oracle trigger
i have a code in sql and wants to do the same kind of thing in oracle,can anybody help me,
CREATE TRIGGER tIU_tblSecApplicationUsers ON dbo.tblSecApplicationUsers
FOR INSERT, UPDATE
AS
RETURN
DECLARE @UserID INT
DECLARE @LoginID VARCHAR(25)
DECLARE @FirstName VARCHAR(25)
DECLARE @MiddleName VARCHAR(25)
DECLARE @LastName VARCHAR(25)
SELECT @UserID = UserID, @LoginID = AppUserName, @FirstName = FirstName, @MiddleName = MiddleName, @LastName = LastName FROM INSERTED
IF UPDATE(AppUserName) OR UPDATE(FirstName) OR UPDATE(MiddleName) OR UPDATE(LastName)
BEGIN
IF EXISTS (SELECT * FROM Users WHERE UserID = @UserID)
BEGIN
UPDATE Users SET
LogonID = @LoginID,
FirstName = @FirstName,
MiddleName = @MiddleName,
LastName = @MiddleName
WHERE UserID =@UserID
END
ELSE
BEGIN
INSERT INTO Users (
LogonID,
FirstName,
MiddleName,
LastName,
UserID
)
VALUES (
@LoginID,
@FirstName,
@MiddleName,
@LastName,
@UserID
)
UPDATE users SET UserId = @UserID WHERE LogonID = @loginID
END
END
especially how to check 'if exists' kind of thing in oracle and 'from inserted'.
please help me
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|