O'Reilly logo

Oracle APEX Cookbook - Second Edition by Marcel Van Der Plas, Michel Van Zoest

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating table APIs

APEX can create a table Application Programmatic Interface (API) for you. A table API is a package that takes care of the DML, rather than having to implement DML yourself. So you will get a package that you can use to insert, update, delete, or retrieve data from the concerning table. The APIs can be referenced from within APEX, so you can call the API from a PL/SQL region. In this way you can keep the database and the client interface separated.

Getting ready

Make sure you have access to the table APP_DEALERS and that this table has a primary key.

How to do it...

  1. Click on SQL Workshop.
  2. Then, click on Utilities.
    How to do it...
  3. Click on Methods on ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required