Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the difference between SQL and PL/SQL?

user-image
Question added by Mohannad Bakbouk , Full Stack Web Developer , Almohtaseb
Date Posted: 2016/10/20
Farhan Siddiqui
by Farhan Siddiqui , Senior Software Engineer , Ellucian

SQL is structured query language to perform data manipulation on database objects, especially tables and views.

PL SQL is procedural language to write advanced logical database objects in oracle database, working as a native language to oracle database.

Eslam Mohammed
by Eslam Mohammed , data warehouse specialist , Abdul Latif Jameel Installment & Leasing

The SQL is Structure Query Language for managing data held in a relational database management system (RDBMS)

The PL-SQL is a proprietary procedural language used by Oracle

Wael Mahmoud Abdul Fatah
by Wael Mahmoud Abdul Fatah , Medical Sales Specialist , Maggie Medical Co.

SQL is the standard of structure query language (SQL) while PL/SQL (Procedural Language/Structured Query Language) is ORACLE delegate of SQL , and it is dedicated to develop SQL and PL/SQL includes procedural language elements such as Conditions and loops, It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces 

  SQL is a query language that allows you to write a single query or execute a single insert/update/delete. PL-SQL is Oracle's "Procedural Language" SQL, which allows you to write a full program (loops, variables, etc.) to accomplish multiple selects/inserts/updates/deletes.

Mohammad Altrkawi
by Mohammad Altrkawi , Technical Team Leader , AESSCO

PL/SQL is a procedural language used to write programmable blocks for Oracle RDBMS. On the other hand, SQL is a special interpreted language used to obtain and manage data in RDBMS.

1.) 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.

Micky Singh
by Micky Singh , Software Test Engineer , Lovely Professional University

SQL is used to write queries,DML and DDL statements and is executed once at a time while PL/SQL is procedural language which is used to create applications basically used to write functions,procedures,blocks and packages etc.

Joji George
by Joji George , Lead Integration Consultant , Kronos Systems

- SQL is used to write queries, DDL and DML statements.

- PL/SQL is used to write programs, views, functions, procedures and triggers

SQL is a data oriented language for selecting and manipulating data in RDBMS while PL/SQL is a procedural language to create programmable blocks or applications.

SQL- it is a structure query language. use to write the query to retrieve, update, modify, add the data from database  by using commands(DDL, DML, DCL)

PL SQL- it is a procedural language. it is used to create  stored procedure, user define function ,trigger etc.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.