Main difference between Oracle and SQL SERVER

Question

Hi... I want to know main difference between Oracle and SQL Server ? Please explain with an example .....? Thanks.....

Vikrant Jadhav · Answer

Hi Vineet The main difference is that MS SQL server is not scalable in that extent that Oracle provides. Oracle can run on all platforms (HW SW) MS SQL - only on Windows and Intel. Oracle has great load balancing architecture - Real Application Server. Oracle has many enhancements but many of them are never used. In the past MS SQL was cheaper. Today it is also an expensive product. Thanks and Regards Vikrant Jadhav Please Mark the Correct Answer. If this post will helpful to you.

Karthika Qpt · Answer

Oracle instance uses a single database whereas SQL Server uses several databases Oracle doesn't have a separate login concept from users (because of the previous bullet) Most of Storing Data connects are same. Both use paging concept (Database) /Row Level Storing concept (Database) /Indexing Concept (Cluster/Non-Cluster) etc. Learn sql basics from https://www.youtube.com/watch?v=7Vtl2WggqOg

Vineet Kumar Saini · Answer

Thanks all my dear....

Datta Kharad · Answer

Hi 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.

Pravin More · Answer

hi vineet if you want to compare from Microsofts point if view... Click Here if you want to compare from Oracle's point if view... Click Here Thanks Pravin.

Prabhu Raja · Answer

I found a similar threat in our forum http://www.c-sharpcorner.com/Forums/Thread/137049/difference-between-oracle-and-sql.aspx

Vilas Gite · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Times New Roman;mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:Times New Roman;mso-bidi-theme-font:minor-bidi;} Hi Vineet.. Please refer : difference features & license cost http://www.dba-oracle.com/oracle_tips_oracle_v_sql_server.htm Thanks! ---------------------------------------------------------------------- If this reply helps your post…then check  This is correct answer

Satyapriya Nayak · Answer

Hi Vineet Please refer the below link http://www.dba-oracle.com/oracle_news/2005_12_16_sql_syntax_differences.htm Thanks