0 votes
in PL/SQL by
Explain what Is The Difference Between Sql And Pl/sql?

1 Answer

0 votes
by

Structured Query Language (SQL) is a non-procedural language that interacts with the database, and is used for database manipulation using the Data Definition Language (DDL) and Data Manipulation Language (DML) statements. Control statements cannot be used in SQL, which is compiled and executed statement by statement at the runtime (late-binding).

PL/SQL is a programming language that allows the usage of Cursor Control statements and Transaction Control statements, such as if...then...else. It integrates with SQL functions and statements to interact and manipulate with the database. Unlike SQL, PL/SQL statements are compiled and processed as a block of code into the machine-readable code, which is executed at runtime (early binding); and therefore, improves the performance.

Related questions

0 votes
asked Mar 15, 2021 in PL/SQL by Robindeniel
0 votes
asked Jun 12, 2023 in Sql by Robin
0 votes
asked Mar 10, 2021 in PL/SQL by sharadyadav1986
...