PL/SQL
1. What is PL/SQL? How is it different from SQL? Answer: PL/SQL (Procedural Language/SQL) is Oracle's procedural extension to SQL. It allows you to write programs with procedural constructs like loops, conditions, and exceptions, which are not possible in SQL. While SQL is used to query and manipulate data, PL/SQL provides more control, flexibility, and the ability to define logic in the database layer. 2. What are the different types of PL/SQL blocks? Answer: PL/SQL blocks can be of three types: Anonymous Block: A block of code that is executed without being stored in the database. Named Blocks (Procedures/Functions): Stored in the database with a name. Packages: A collection of procedures, functions, and variables grouped together. 3. What is the purpose of the "DECLARE" section in PL/SQL? Answer: The DECLARE section is used to declare variables, constants, cursors, and exceptions before the executable part of the PL/SQL block. It is optional, and if not needed, ...