0
- Platform dependency-
The primary difference is with respect to platform dependency, SQL is basically limited to the Windows platform where as Oracle is operable on multiple platforms such as Windows, UNIX and Linux etc. This multi-platform compatibility of Oracle makes it a universal enterprise solution, which makes it mandatory for the Oracle DBA to be acquainted with the different platforms where as the Sql DBA just needs to be familiar with the windows platform..
- Clustering technology-
Oracle is significantly ahead of its opponent when it comes to clustering technology, Oracle makes use of RAC technology which enables two instances to act on the same data in active-active configurations.
- Locking and concurrency -
Oracle had a multi-version consistency model which means that "readers don't block writers and writers don't block readers." Sql on the other hand has a very simple locking mechanism which follows the rule that "writers block readers and readers block writers."
- File system-
Oracle includes IFS (internet File System), Java integration, SQL is more of a pure database.
- Replication -
SQL Server provides a far more simple and flexible system for replication and synchronizing of data when compared to Oracle, it involves a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.
- Administration-
SQL server GUI is simple and easy to work with where as the Oracle server is not very user friendly as most of it command line is based.
by....... Sankar
What else can I help you with?
What is the difference between a stored database procedure and a batch of SQL statements submitted by a client application?
Stored procedures prevent unauthorized access to data
Can i get a SQL Certification online?
You can obtain an SQL certificate online. Simply query online SQL certificaiton.
Pl sql programs executes in sql server?
PL\SQL is an Oracle product (the PL stands for procedural language), while Sql Server most commonly refers to Microsoft SQL Server, although at one point Sybase also marketed its product as Sql Server. Microsoft and Sybase both have a procedural language feature, called T-SQL (Transact-SQL), which is similar in concept to PL\SQL, but there are significant differences in syntax and structure. An experienced developer could convert PL\SQL to T-SQL readily, but conversion would be required. It would not run without conversion.
Will SQL training teach me how to do SQL injection on websites?
No, it will not. SQL injections are primarily used for malicious purposes, and will not be specifically taught in a legitimate SQL training course. You would, however, probably gain the knowledge necessary to understand and apply SQL injections. You will learn how to deal with SQL databases with websites. You will also learn how to design databaseses.
What is use of IN clause and between clause in sql?
It allows you to easily test if an expression is within a range of values (inclusive).
Is it possible to change the structure of existing view if yes then how?
using plsql sql
How do you compile a PLSQL procedure?
You can do that with Sql*Plus: SQL> CREATE OR REPLACE PROCEDURE foo ... IS ... END foo; / SHOW ERRORS
What is PLSQL?
The Oracle Corporation's application development language is PL/SQL. It is a superset of SQL that uses standard programming-language to supplement the SQL. PL/SQL stands for Procedural Language/Structured Query Language.
Which is an example of a PLSQL subprogram?
A PL/SQL subprogram is equivalent to a procedure or function in conventional procedural programming.
What is the difference between T-sql and sql?
T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
What is the difference between hql and sql?
one of the difference is HQL does not support distinct but SQL supports the distinct in the query
What are stored procedures in data bases?
Stored procedure is the pl-sql block in precomplile from and can be used to excecute plsql statement
Difference between sql and sql plus?
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
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 difference between quel SQL and qbe?
gand maro...is the answer
What is sql and plsql?
SQL stands for Structured Query Language, and is a computer language designed for writing data manipulation or data management statements against a relational database. PL/SQL stands for Procedural Language/Structured Query Language which is Oracle's proprietary procedural extensions to the SQL language.
Difference between SQL Exception class and SQL Warning class?
sql exception which provides information on database access errors where as sql warning provides inforamation on database access warnings.
