ITP

BSc IT - Advanced Database Management System

Difference between PL/SQL and SQL.

In : BSc IT Subject : Advanced Database Management System

SQL (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.

About us

A truly open platform where you may ask questions and get answers. We also provide comprehensive and easy-to-understand answers to question papers.  discover...

Site status

Flag Counter

Privacy Policy

Sitemap