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

Is sql statements in oracle and sql server are same?

 
saikrishna cinux
Ranch Hand
Posts: 689
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello

i know sql in oracle 8i.
so here i am using classes12.jar file as a jdbc drivers for connecting java to database.

and i now need to connect it to SQLSERVER so do i need to learn the quries in sqlserver or can i use the same sql statements of oracle8i.?

and also can use same classes12,jar file connecting to the DB from java.?

plz can any one explain me
thanks in advance

cinux
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by saikrishna cinux:
now need to connect it to SQLSERVER so do i need to learn the quries in sqlserver or can i use the same sql statements of oracle8i.?


If your queries are following ANSI SQL standard then you need not to change your sql statements.
It is unlikely that an application do not have database specific queries so you need to understand sql server queries.


use same classes12,jar file connecting to the DB from java.?


You will have to use vendor specific jar files to connect with database

Shailesh
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic