PL is a procedural language. It is an extension of SQL. PL adds programming language features to SQL statements. It organizes data operations and query statements in procedural code. It uses logical judgments, loops, and other operations to implement complex functionality.
You can use PL to write programs with many advanced features. You can encapsulate business logic in a database. This improves abstraction and security. PL reduces network interactions and improves call speed. This improves overall performance.
The main advantages of PL are as follows:
High performance
When you use PL to interact with a database, the database server handles all processing logic and returns only the required results to the client. This greatly reduces data exchange between the application server and the database server. It saves network resources and processing time.
PL objects are stored in a database in a precompiled form. Compared with SQL, the optimizer optimizes PL objects better and executes them more efficiently.
Easy development
Many features of PL can save developers' time for development design and error troubleshooting. Developers can use OceanBase Developer Center (ODC) for efficient development.
For more information, see the ODC-related documentation on the OceanBase website.
Portability
For database developers, PL is a portable standard language. PL applications can run in any OceanBase database.
Easy management
PL objects are stored in a database. When you modify an application or update its version, you only need to modify the PL objects in the database. All applications immediately take effect. You do not need to worry about the differences in client code updates.