Home / Educational Content / Database & Technology / Implementing Business Rules Code with a PL/SQL Table API

Implementing Business Rules Code with a PL/SQL Table API

Presented at INSYNC 21

Session ID: 100720

Business rules define the requirements of the organization such as what constitutes valid data. A PL/SQL Table API provides a centralized location for the code you write to represent those business rules. This technique has many benefits including better performance, reduced cloud database costs, simplification of user interface code, and more secure applications, and it can be used for any development environment: APEX, ADF, MAF, JET, MAX, VB Studio, Java, JavaScript, or any other framework.

Attend this session to hear about the benefits of this kind of centralized code in more detail as well as some advice about how to incorporate it into your development practices. The presentation focuses on the code components and strategies relevant to using a PL/SQL Table API and the methods used to call it. It also describes and demonstrates methods for automatically generating a large part of the code and shows examples of generated code as well as code that calls the Table API.

Watch the full-length video

Access our complete catalog of webinars, blogs and customer stories. Leverage insight from across the community through our library of 4,000+ educational resources.

Implementing Business Rules Code with a PL/SQL Table API