Hi, I have a VB project using SQ

[quisar]

Hi,

I have a VB project using SQL Server 2000. Now I want to use the same code for Oracle. Can this be done without changing the SQL statement used? Is there any tool in the database itself or any third party utility?

Thanks,

Quisar

 

[SQLSister]

As with most things in the computer world, it depends. If you SQL is fairly simple (Such as selec tfield 1 from table1) you might be OK. However, T-SQL and the flavor of SQL used by Oracle do often have differing syntax, you'll just have to check every query and see. The O'Reilly book, SQL in a Nutshell by Kebin and Daniel Kline does show the differences in how both handle the SQL for various tasks.