| Author |
Is sql statements in oracle and sql server are same?
|
saikrishna cinux
Ranch Hand
Joined: Apr 16, 2005
Posts: 689
|
|
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
|
A = HARDWORK B = LUCK/FATE If C=(A+B) then C=SUCCESSFUL IN LIFE else C=FAILURE IN LIFE
SCJP 1.4
|
 |
Shailesh Chandra
Ranch Hand
Joined: Aug 13, 2004
Posts: 1076
|
|
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
|
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
|
|
 |
|
|
subject: Is sql statements in oracle and sql server are same?
|
|
|
0
