Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

sql
psql
database

SQL vs PL/SQL

Educative Answers Team
svg viewer

 

Structured Query Language (SQL)

       

  1. SQL is a data oriented language which is primarily used to access and make changes to the data using simple queries like insert, update and delete.  

  2. It is simply used to write the Data Declaration statements as well as Data manipulation statements.

  3. Statements control the database by telling it which operations to perform.

  4. Can execute multiple operations, such as insert, update, delete, and select in a single query.

  5. Always gives system error messages after an invalid transaction.

  6. Doesn’t support code reusability, which means you need to write insert, update, delete, and select every time we need to use them.

  7. Directly interacts with the database server.

  8. Used to maintain data, create analytical reports, web pages, and screens.

 

Procedural Language Structured Query Language (PL/SQL)

 

  1. PL/SQL is a procedural language which is primarily used to create applications and add business logic i.e., manage communication between an end user interface and a database.

  2. It is simply used to write procedures, views, functions, packages and triggers.

  3. Statements tells the database how to perform operations.

  4. Can execute multiple queries simultaneously.

  5. Converts system error messages into comprehensive error messages when using exception handling.

  6. Supports code reusability, which means you only have to write the code once and can reuse that code whenever you need to perform the same operations.

  7. Does not directly interact with the database server.

  8. Used to create applications and add the business logic for specific module or for specific application.

RELATED TAGS

sql
psql
database
Copyright ©2022 Educative, Inc. All rights reserved
RELATED COURSES

View all Courses

Keep Exploring