Solved

Oracle Vs MS SQL Server 2000

Posted on 2004-10-27
151 Views
Last Modified: 2013-12-24
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
0
Question by:CFDevHead
    10 Comments
     
    LVL 35

    Accepted Solution

    by:
    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
     
    LVL 35

    Expert Comment

    by:mrichmon
    This may also be useful
    It compares functions in the two and gives the equivalents...
    http://www.webucator.com/resources/sql/reference.html
    0
     
    LVL 35

    Expert Comment

    by:mrichmon
    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
     
    LVL 9

    Author Comment

    by:CFDevHead
    so from what I have read I wont have to re-write my sql queries
    0
     
    LVL 9

    Author Comment

    by:CFDevHead
    most of my are writing like this
    select R.B from R, S where R.B = S.B;
    0
     
    LVL 17

    Assisted Solution

    by:Tacobell777
    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
     
    LVL 17

    Expert Comment

    by:Tacobell777
    having said that, Oracle is one hell of a beast to tame ;-))
    0
     
    LVL 9

    Author Comment

    by:CFDevHead
    thanks to all
    0
     
    LVL 9

    Author Comment

    by:CFDevHead
    one other thing is Oracle cas senitive?`
    0
     
    LVL 35

    Expert Comment

    by:mrichmon
    Usually Yes
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
    Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
    This video discusses moving either the default database or any database to a new volume.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    846 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now