Equivalent Oracle Code

[diwakar]

Hi,

Could anyone provide me an Oracle equivalent code/Logic in SQL Server, for this below mentioned code in SQL Server.

Regards,

K.Diwakar

UPDATE ISQM.texaminations
SET DateApproved = CURRENT_TIMESTAMP,
UserApproved = @UserID
FROM ISQM.tbatches B
INNER JOIN ISQM.teventsbatches EB
ON B.SystemID = EB.SystemID
AND B.BatchID = EB.BatchID
INNER JOIN ISQM.tevents V
ON EB.SystemID = V.SystemID
AND EB.EventID = V.EventID
INNER JOIN ISQM.texaminations X
ON V.SystemID = X.SystemID
AND V.EventID = X.EventID
WHERE B.BatchID = @BatchID
AND B.SystemID = @SystemID

[marist89]

tahiti.oracle.com