File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 15286
    
    6

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


GenRocket - A Test Data Generation Platform
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
Oracle very slow than sybase when there is multiple joins among tables
I Passed!!! 76% What Now?
Typical extension to storedProcedures and packages
select all the colums although some empty/null
Stored Procedure Making Two different Server Database Call