Can anyone help me re write this sql server code into Oracle PL/SQL code.. ...I am using oracle 8i which is quite old and i am not so good in coding.

UPDATE A
 SET STDCOST = B.Cost
  FROM Table_A A
  INNER JOIN Table_B B
  ON (A.ITEM = B.Item) AND (A.Location = B.Location) ;

PS: remember syntax (table_a inner join table_b) dont work in 8i