Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Sybase to Oracle conversion. (SQL)

 
lvkiran
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
lvkiran,
Please change your Display Name to conform to our Naming Policy.
Thank you
 
Sainudheen Mydeen
Ranch Hand
Posts: 218
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:

If there are three tables involved:

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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic