It's not a secret anymore!*
The moose likes JDBC and the fly likes Sybase to Oracle conversion. (SQL) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Sybase to Oracle conversion. (SQL)" Watch "Sybase to Oracle conversion. (SQL)" New topic
Author

Sybase to Oracle conversion. (SQL)

lvkiran
Greenhorn

Joined: May 14, 2003
Posts: 3
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
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

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


GenRocket - Experts at Building Test Data
Sainudheen Mydeen
Ranch Hand

Joined: Aug 18, 2003
Posts: 218
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Sybase to Oracle conversion. (SQL)
 
Similar Threads
I Passed!!! 76% What Now?
Typical extension to storedProcedures and packages
Stored Procedure Making Two different Server Database Call
Oracle very slow than sybase when there is multiple joins among tables
select all the colums although some empty/null