Difference between SQL and PL SQL

Question

Hi!!

Can someone tell me the difference between  SQL and PL/SQL?

Answer 1

SQL is a query language that allows you to issue a single query or execute a single insert/update/delete whereas PL/SQL is Oracle’s “Procedural Language” SQL, which allows you to write a full program (loops, variables, etc.) to accomplish multiple operations such as selects/inserts/updates/deletes.

Answer 2

In Oracle database administration, there are two languages namely SQL and PL SQL. these two languages perform database related queries.

SQL is a structured query language that performs single operations.

Whereas PL SQL is the advanced version of SQL language. Here we can perform several crude operations at a time. So hence it requires some programming.

This is the main difference SQL and PL SQL in Oracle DBA

If you need to know more about SQL, it is recommended to go for the SQL Course today.

Answer 3

We can differentiate these on basis of following key points:

Full Form

SQL stands for Structured Query Language whereas PL/SQL stands for Programmable Structured Query Language.

Basic Usage

In SQL, we can execute single command or query at a time. The query can be and DDL (Data Definition Language) or DML (Data manipulation language). DDL is used to add, remove or modify tables(db objects). DML is used to Insert, update or delete data from tables.

On the other hand, PL/SQL is bloc of commands or code which helps us to accomplish multiple task at a time. It can consist of several SQL queries, loops, functions. So many tasks are performed at a time here.

I found useful resource at- Difference Between sql and plsql: Insight with Example Query