Let’s have a look at some of the differences between SQL, PLSQL and Oracle.
SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn’t include all the things that normal programming languages have, such as loops and IF…THEN…ELSE statements.
PL/SQL is a normal programming language that includes all the features of most other programming languages. But, it has one thing that other programming languages don’t have: the ability to easily integrate with SQL.
Some of the differences:
* SQL is executed one statement at a time. PL/SQL is executed as a block of code.
* 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).
* SQL is used to code queries, DML and DDL statements. PL/SQL is used to code program blocks, triggers, functions, procedures and packages.
* You can embed SQL in a PL/SQL program, but you cannot embed PL/SQL within a SQL statement.
Oracle is a software package, a database platform that is used to handle or to maintain the database. SQL is a language that is used by relational database technologies such as Oracle, Microsoft Access, and Sybase etc., PL/SQL is commonly used to write data-centric programs to manipulate data in an Oracle database. PL/SQL language includes object oriented programming techniques such as encapsulation, function overloading, and information hiding (all but inheritance).
In simple words, SQL and PLSQL are languages used to access data within oracle databases.