Access SQL update to Oracle SQL 2

[jjob]

I have the following Access SQL, from a Query

UPDATE User 
INNER JOIN TempUser ON User.Comp_ID = TempUser.CompID 
SET User.FirstName = [TempUser]![FirstName], User.SecondName = [TempUser]![SecondName];

I am required to convert this into an Oracle stored procedure, and wanted to maintain a single update statement, but despite various efforts, I cannot write an Oracle version that compiles. The only caveat is that I have never actually seen the Access code working, although I am told it does.

Before I abandon this, and write it using cursors in PL/SQL, can anyone suggest an Oracle translation of this statement?

TIA

John

 

[sem]

If CompID is unique key for TempUser this should work:

UPDATE 
(select U.FirstName UFirstName
,T.FirstName TFirstName
, U.SecondName USecondName
, T.SecondName TSecondName
from User U, TempUser T
WHERE U.Comp_ID = T.CompID)
set UFirstName=TFirstName
,USecondName=TSecondName

Regards, Dima

http://seminihin.narod.ru

 

[jjob]

Many thanks Dima, I've been really struggling to find out the oracle syntax for this.

John