Difference between SQL and PL/SQL

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.
Write a PL/SQL program for a function
Write a PL/SQL program for a function - PL/SQL program...
What are the types PL/SQL code blocks?
What are the types PL/SQL code blocks? - Anonymous Block: It is a block of codes without a name...
Advantages of PL/SQL
Advantages of PL/SQL - Support SQL data manipulation, Provide facilities like conditional checking, branching and looping...
Post your comment
Discussion Board
sql
SQL is a Structured Query Language used to issue a single query or execute a single insert/update/delete.

PL-SQL is a programming language SQL, used to write full programs using variables, loops,operators etc. to carry out multiple selects/inserts/updates/deletes. learn sql from https://www.youtube.com/watch?v=7Vtl2WggqOg
karthikaqpt 04-23-2016