Sybase to Oracle conversion. (SQL)

[lvkiran]

Hi All,
How to conver the following from SYBASE to ORACLE.
UPDATE Tb_A A
SET A.VAL1 = B.VAL1
, A.VAL2 = B.VAL2
FROM Tb_B B, Tb_C C
WHERE B.id = C.id
please throw some light on this.
thx

[Gregg Bolinger]

lvkiran,
Please change your Display Name to conform to our Naming Policy.
Thank you

[Sainudheen Mydeen]

Hi
Are you sure you can run your query sucessfully in sybase? Because I don't see a condition in your query which uniquely identify which row of Tb_A to be updated. If you are using two tables you can do the following in oracle:

update Tab1
   set (a.Val1, a.Val2) = (select b.Val1, b.Val2
                             from Tab2 b
                            where a.id = b.id);
                              

If there are three tables involved:

update Tab1 a
   set (a.Val1, a.Val2) = (select b.Val1, b.Val2
                             from Tab2 b, Tab3 c
                            where b.id = c.id
                              and a.id = b.id)   

Both queries clearly define which record of Tab1 to be updated. You may change the condition according to your need.
-Sainudheen
[ October 07, 2003: Message edited by: Sainudheen Mydeen ]