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
Wiki User
∙ 11y ago
Wiki User
∙ 9y ago1.) SQL is a data oriented language for selecting and manipulating sets of data. PL/SQL is a procedural language to create applications.
2.) PL/SQL can be the application language just like Java or PHP can. PL/SQL might be the language we use to build, format and display those screens, web pages and reports.SQL may be the source of data for our screens, web pages and reports.
3.) SQL is executed one statement at a time. PL/SQL is executed as a block of code.
4.) SQL tells the database what to do (declarative), not how to do it. In contrast, PL/SQL tell the database how to do things (procedural).
5.) SQL is used to code queries, DML and DDL statements. PL/SQL is used to code program blocks, triggers, functions, procedures and packages.
6.) We can embed SQL in a PL/SQL program, but we cannot embed PL/SQL within a SQL statement.
Wiki User
∙ 9y agoIn database management system to access or modify data query is generated. SQL is strutured query language used to retrieve or modify data. While PL/SQL is programming language of SQL to create applications.
Wiki User
∙ 13y agoOracle is a software company.
SQL (Structured Query Language) is a language for manipulating or retrieving information from a Relational Database system.
Wiki User
∙ 13y agoOracle is one of the popular database and DBA (DataBase Administrator) is the person who maintain the database (install oracle software, create,setup,maintain database)
Add your answer:
Earn +20 pts
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).
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
Is it possible to change the structure of existing view if yes then how?
using plsql sql
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
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 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
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.
