SQL Server - what is the difference between sql server and oracle

Asked By Mahindra E on 21-Jun-12 08:43 AM

explain the differences between oracle and sql server
Chintan Vaghela replied to Mahindra E on 21-Jun-12 08:46 AM
SQL Server is MicroSoft Product

Oracle is Multinational Company
Mahindra E replied to Chintan Vaghela on 21-Jun-12 08:47 AM

am not asking about the companies, sql server and oracle databases
Chintan Vaghela replied to Mahindra E on 21-Jun-12 08:53 AM
  1. Oracle runs on many platform when sqlserver runs only on Window
  2. Oracle support SnapShot when SQL server not support
  3. Oracle support Trigger for each row when Sql server not support
  4. Oracle support Package and CLuster for each row when Sql server not support

Check following link for more details


RAJASEKHAR RAJENDRAN replied to Mahindra E on 21-Jun-12 09:03 AM

You can find a detailed differences between the sql server and oracle in the below site

Apart from the Above,

The Syntax Differences between the two are shown below

The below shows the different type of index supported by both.

Thanks & Regards,
Jitendra Faye replied to Mahindra E on 21-Jun-12 09:07 AM
Refer these links-

Gorav Handa replied to Mahindra E on 21-Jun-12 09:09 AM
They have different architecture. The basic differences are below:
1. All the stored procedures are stored in packages which are like C# namespaces
2. Oracle has connect by prior clause for tree like query
3. Cursors in oracle are more optimized
4. Oracle has cursor for loop construct
5. PL Sql is used of programming
6. For returning records to .Net DAL ref cursors are used
7. TOAD & PL SQL Developer can be used as IDE
There are lot of things like this
Sql Server
1. T- SQL is used for programming
2. Top clause is valid in Sql server
3. We can use CTE for tree like query
4. For returning records to .Net DAL simple select statement is enough
5. IDE is more powerful and have lot of flexibilities
6. .Net CLR integration is supported as it is Microsoft's product
There are lot of things like this
aneesa replied to Mahindra E on 21-Jun-12 11:50 PM
Difference between Oracle and SQL Server:-
1) The FIRST biggest difference: Transaction control. In Oracle EVERYTHING is a transaction and it is not permanent until you COMMIT. In SQL Server, there is (by default) no transaction control. An error half way through a stored procedure WILL NOT ROLLBACK the DDL in previous steps.
Obviously, if you wrap the TSQL DML in BEGIN TRANSACTION and COMMIT then it will roll back but this is rare in SQL Server code I've seen.
2) The SECOND biggest difference: MVCC. In SQL Server and Oracle is different. SQL Server will allow dirty reads, and writes can block reads in MS SQL (Again, it's configurable but the default in SQL Server is for performance and not read consistency, unlike Oracle where read consistency is default and unbendable.
* Get date and time:-
Oracle:- select sysdate from dual;
SQL Server:- select getdate();
Consider these things:-
1) When you setup an Oracle server, you tend to have one database with many "users/schemas", and tablespaces that are shared by all your users. SQL Server has separate databases that do not share disk files.
2) SQL Server uses "logins" to give you access to the SQL Server instance and each database has "users" that map to a login to get individual access to the tables and views etc.
3) Typically, all the objects in a database are owned by dbo.
4) TSQL is similar to PL/SQL, but (in my opinion) less powerful. You may need to simplify your SQL to get it to work as well as you'd expect in Oracle.
5) The SQL Server Management Studio (2008 SP1) is fantastic!
6) If you like Oracle, all the "getting under the hood" and "explain plan optimisation" then this training and experience will work well for you against guy's who just code straight SQL Server TSQL and expect the server to perform fast by magic.
7) SQL Server does not have packages. This might start off as a bonus (PL/SQL packages can be a PITA) but eventually you'll start to get a big nest of similarly named stored procedures in the database and you'll wish there was a way you could organise and group then them better.
Lalit M replied to Mahindra E on 22-Jun-12 01:52 AM
Read here diff
1. Oracle runs on many platforms, SQL on Windows only
2. Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database
3. Oracle requires client install and setup (Not difficult, but very UNIX-like for Windows users)
4. SQL is #1 in Cost/Performance and overall Performance, although Oracle will refute that
5. Replication is much easier in SQL.
6. Failover support in SQL is much, much easier
7. JDBC support is much better in Oracle, although Microsoft is working on it
8. ODBC support in both
9. SQL is ANSI-SQL '92 compliant, making it easier to convert to another ANSI compliant database, theoretically anyway (truth is every database has proprietary extensions). Oracle is generally more proprietary and their main goal is to keep their customers locked-in.
10. SQL natively supports ODBC, OLEDB, XML, XML Query, XML updates. Oracle natively supports proprietary connections, JDBC. Not sure about XML support though.
11. SQL Server is much easier to administrate, with GUI and command- line tools. Most of Oracle is command-line.
12. Oracle requires add-ons for transaction monitors, failover, etc. SQL has COM+, uses NT clustering and generally has everything built-in
 13. SQL Analysis Services is included (A very powerful OLAP server).