Hi Everyone, Today's topic is PL/SQL introduction.
PL/SQL stands for “Procedural Language extensions to the Structured Query Language”.
SQL is a popular language for both querying and updating data in the relational database management systems (RDBMS).
PL/SQL adds many procedural constructs to SQL language to overcome some limitations of SQL. Besides, PL/SQL provides a more comprehensive programming language solution for building mission-critical applications on Oracle Databases.
PL/SQL = PL(procedure Language(Programming language)) + SQL(structured Query Language)
Features of PL/SQL:
PL/SQL is a highly structured and readable language.
PL/SQL is a standard and portable language for Oracle Database development
PL/SQL is an embedded language. PL/SQL only can execute in an Oracle Database.
PL/SQL is a high-performance and highly integrated database language.
Architecture of PL/SQL :
Once you submit a PL/SQL block to the Oracle Database server, the PL/SQL engine collaborates with the SQL engine to compile and execute the code. PL/SQL engine runs the procedural elements while the SQL engine processes the SQL statements.
Disadvantages of PL/SQL :
1. PL/SQL requires high memory.
2. Lacks of functionality debugging in stored procedures.
Now move forward to Blocks in PL/SQL .
Thank you for reading.
Ask your Doubt or Query in Comment Sections.