Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (9k points)
What is the difference between SQL and PL/SQL?

1 Answer

0 votes
by (45.3k points)

SQL stands for Structured Query Language. It is a database query language used to execute a command or a single query at a time. It is a source of data that needs to be displayed. You can write commands as well as queries using Data Manipulation language (DML) and Data Definition Language (DDL) statements. You can use SQL to add, modify, retrieve, manipulate, or delete data from the database. SQL statements can be embedded in PL/SQL.

PL/SQL, on the other hand, is a procedural language extension to SQL. It is used to execute a single block of code at once. It creates an application that helps to display SQL’s acquired data. You can use PL/SQL to write a block of code with functions, procedures, variables, and packages. Also, you can use PL/SQL to create server pages or applications that can display the data from SQL in a comprehensive format. PL/SQL statements cannot be embedded in SQL.

If you want to learn in-depth about this database query language, enroll in an online SQL Training.

You should also watch this video to learn more about the difference between SQL and PL/SQL:

Related questions

0 votes
1 answer
0 votes
1 answer
asked Dec 10, 2020 in SQL by dev_sk2311 (45k points)
0 votes
1 answer
asked Oct 19, 2020 in SQL by dev_sk2311 (45k points)
0 votes
1 answer
asked Jan 29, 2020 in SQL by anmolj (9k points)
0 votes
1 answer
asked Oct 20, 2020 in SQL by dev_sk2311 (45k points)

Browse Categories

...