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.