Difference between PL/SQL and SQL.
In : BSc IT Subject : Advanced Database Management SystemSQL (Structured Query Language) is a language used to interact with relational databases. It is used to perform operations like querying data (SELECT), inserting (INSERT), updating (UPDATE), and deleting (DELETE) data, as well as defining and controlling access to database objects. SQL is declarative , meaning you tell the database what you want, not how to do it.
PL/SQL (Procedural Language/SQL) , on the other hand, is Oracle's extension to SQL that adds procedural programming features like loops, conditions, variables, and functions. It allows you to write full programs that can process data and perform complex logic. Unlike SQL, PL/SQL lets you write blocks of code that can include multiple SQL statements along with control structures like IF-THEN-ELSE, FOR LOOP, and WHILE LOOP.