Comparing Oracle and MS SQL - Interviewing for a job

Posted on 2005-05-12
Medium Priority
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

leonstryker earned 1000 total points
ID: 13988997
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

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

850 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