【PL/SQL】PL/SQL和SQL的区别

PL/SQL:
-Procedural Language extension to SQL
-Oracle Corporation’s standard data access language for relational databases

-Seamlessly integrates procedural constructs with SQL
-Block structure to excitable units of code
-maintaining and debugging is made easier

-Provides procedural constructs such as:

• Variables, constants, and data types
• Control structures such as conditional statements and loops
• Reusable program units that are written once and executed many times

-offers modern software engineering features(data encapsulation, exception handling, information hiding, and object orientation)
-provides all the procedural constructs that are available in any third-generation language (3GL).

Benefits of PL/SQL:
-Integration of procedural constructs with SQL
-Improved performance:

• Modularized program development

-Integration with Oracle tools

• Portability
• Exception handling

SQL:
-Structured Query Language
-the primary language used to access and modify data in relational databases