Explain difference between SQL and PL/SQL.
SQL is Structured Query Language comprising of Data Definition Language (DDL) and Data Manipulation Language (DML). DDL is used to define the scheme while DDL is used to manipulate the data.
Example of DDL:-
CREATE TABLE SAMPLE
(
Name varchar(100)
);
Example of DML:-
Insert into sample values(‘john’);
PL/SQL on the other hand is Procedural extension of SQL. It has features like encapsulation, overloading, exceptions etc.
SQL is mainly a data oriented language while PLSQL is a procedural language used to create applications. Normally, it is not heard that the application is SQL based. SQL is usually used as a relational database.