Oracle APEX Methods on Tables | Integration API

The Managing Methods on Tables utility enables you to create an application programming interface, or package, based on a specified table.

To create a package:

On the Workspace home page, click the SQL Workshop.
Click Utilities.
Click Methods on Tables.
The Create Table API page appears.

Enter a Package name. To have the final package name match the case entered in the Package Name field, click Preserve Case and click Next.
Select the table(s) for which you want to generate the PL/SQL package-based application program interface (API) and click Next.
A confirmation page appears, which displays the subprogram(s) and their description. You have the option to show or download the specification or body. To confirm, click Create Package.

#oracleapex #oracleace #erpstuff

[skamransajjad]

Very useful, please share usage examples as well.

[karely]

4:16 on adding business logic, validations: how can we add business logic without it being overwritten when we regenerate the package after a table change.

[youshark]

Very Nice Tool< but we need more about MD5