Comparing Oracle and MS SQL - Interviewing for a job

Posted on 2005-05-12
Last Modified: 2012-05-05
My background is MS SQL which i am familiar and had never work with Oracle and I am applying for a position with Oracle backend. Let me know what important things to know for the interview.
I would like to know where are the salient differences between MS SQL 2000 and Oracle as far as:

1. DB Structure

2. Calling Stored procedures

3. Administration -Managing tables, permissions

4. Where the advantages of each?

i'd like to expalin this within the light of application development being VB as the front end and Oracle as backend.

Question by:zachvaldez
    1 Comment
    LVL 29

    Accepted Solution

    1. There is really only one database.  Pieces are allocated for various grouping of tables.

    2. Very different.  Procedures do not return Select statements.  There are syntax difference between T-SQL and PL-SQL.

    3. Generally the same, but sytax differences

    4. There are many article on this.  Generally Oracle is considered more rubust and faster (all of these are debatable).  SQL Server is cheaper (not debatable)

    From the application development point there is not much of a difference.  The major isssue is will be the creation of store procedures, but it is not a problem as long as you are aware of it.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

    728 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

    20 Experts available now in Live!

    Get 1:1 Help Now