Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi, I have a VB project using SQ

Status
Not open for further replies.
quisar

quisar

Programmer
Aug 21, 2002
45
IN
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
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
536
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
634
Mike Lewis
Mike Lewis
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
859
SashaBuilder3
SashaBuilder3
MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
379
Chriss Miller
C
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
875
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top