answersLogoWhite

0

What is deffirence between sql server 2005 and oracle?

Updated: 8/16/2019
User Avatar

Wiki User

11y ago

Best Answer

oracle runs on any platform whereas sql server runs only on windows.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is deffirence between sql server 2005 and oracle?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Difference between sql server 2003 sql server 2005?

There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.


What is the programming language does enovia use?

It's JAVA based on the front end with Html and Javascript for the web interface. The backend can be either Oracle or SQL Server 2005/2008 -- with SQL Server 2008 being be better performance over Oracle on the same hardware and lower cost.


What are the similarities between oracle dbms and access dbms?

Oracle and Access are both RDBMS's (Relational Database Management Systems). Consequently they both use tables which have 'keys' to retrieve rows, and use 'foreign keys' to other tables to 'relate' those rows together. Oracle and Access also both use SQL (Structured Query Language) to allow you to use the database (for example: "select * from customer_table where customer_number = '12345'"), although you can use tools which provide a more graphical environment to produce the underlying SQL. The real difference between the two is that Oracle is an industrial strength RDBMS.


When was Oracle Tower Bucharest created?

Oracle Tower Bucharest was created in 2005.


What are the differences between sql and mysql?

SQL is short for Structured Query Language, and MySQL is a database management system, like SQL Server 2005, Oracle.An example would be other programming languages like BASIC and QBASIC where BASIC is the generic term for the BASIC programming language and QBASIC is Microsoft's version (quick BASIC) and TURBO BASIC was Borlands version.oracle supports the user defined datatypes,where as mysql not support all these types of datatypes, like user defined , and cursors like these stuff;;


Describe IDE of SQL Server 2005?

An IDE for SQL Server 2005 refers to an Integrated Development Environment for SQL Server 2005. This is a tool that can be used by a programmer to create and maintan a SQL server database. Some commonly used IDE tools for SQL Server 2005 are:SQL Server Management StudioTOAD for SQL ServerTOAD for Data Analysts


How you delete duplicate row of table in SQL?

This can be different depending on the SQL server involved. Please specify the Database being used (ie, mysql, postgresql, oracle, ms SQL Server) I am using SQL 2005 express, what is the command, i can only get... delete... and what else? lets say i want to delete a duplicate row that is row 2.


When was SQL Server Management Studio created?

SQL Server Management Studio was created in 2005.


When was Subsonic - media server - created?

Subsonic - media server - was created on 2005-02-10.


Where can one get SQL Server 2005 downloads?

The best way in order to get an SQL Server 2005 installation package would be to go to the related Microsoft SQL Server 2005 download page. The "Express" edition is free of cost and can be redistributed with own applications - all other versions of Microsoft SQL server can only be legally purchased.


Diff between sql server 2000 and sql server 2005?

Hi Everybody, I am Vijay.According 2 me the differences are: 1. In SQL Server 2000 the Query Analyzer and Enterprise Manager are seperate,whereas in SQL Server 2005 both were combined as Management Studio. 2. In Sql 2005,the new datatype XML is used,whereas in Sql 2000 there is no such datatype 3. In Sql server2000 we can create 65,535 databases,whereas in Sql server2005 2(pow(20))-1 databases can be created.


What kind of databases and database servers does MySpace use?

MySpace is use Microsoft SQL server 2005 for database & database server.