Oracle Vs MS SQL Server 2000

I am curently looking at switching from MS SQL Server to Oracle I need to some of the big differences between the two please help
LVL 9
CFDevHeadAsked:
Who is Participating?
 
mrichmonCommented:
I would say there aren't a lot of BIG differences, but a bunch of small ones.

Maybe this will help:
Comparison of SQL Server 2000 and Oracle 9i
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm

One thing you may hit right away is the name length difference (details also in above article) but they are shorter than in SQL.
0
 
mrichmonCommented:
This may also be useful
It compares functions in the two and gives the equivalents...
http://www.webucator.com/resources/sql/reference.html
0
 
mrichmonCommented:
One more good link I just found with a quick google search

Oracle 9i SQL versus Standard SQL
http://www-db.stanford.edu/~ullman/fcdb/oracle/or-nonstandard.html

0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
CFDevHeadAuthor Commented:
so from what I have read I wont have to re-write my sql queries
0
 
CFDevHeadAuthor Commented:
most of my are writing like this
select R.B from R, S where R.B = S.B;
0
 
Tacobell777Commented:
Make sure you don't use any functionality native to MS SQL, like system stored procedures, functions etc.

I think you'll be in for a lot of changes when you switch over, unless you used only standard SQL...
0
 
Tacobell777Commented:
having said that, Oracle is one hell of a beast to tame ;-))
0
 
CFDevHeadAuthor Commented:
thanks to all
0
 
CFDevHeadAuthor Commented:
one other thing is Oracle cas senitive?`
0
 
mrichmonCommented:
Usually Yes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.