PL is a procedural language (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 and loops to implement complex features.
You can use PL to develop programs with advanced features. You can encapsulate business logic in the database, which improves abstraction and security. PL reduces network interactions and improves call speed, thereby improving overall performance.
PL has the following advantages:
High performance
When you use PL to interact with a database, the database server processes all logic and returns only the required results to the client. This greatly reduces data exchange between the application server and the database server, saving network resources and processing time.
PL objects are stored in the database in a precompiled form. Compared with SQL statements, PL objects are better optimized by the optimizer and executed more efficiently.
Easy development
PL provides many features that help developers save time on development design and error troubleshooting. You can use OceanBase Developer Center (ODC) for efficient development.
For more information, see the ODC 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 the database. When you modify applications or upgrade versions, you only need to modify the PL objects in the database. All applications take effect immediately, and you do not need to worry about the differences in client code.