The Oracle APEX blog is your source for APEX news, technical tips and strategic direction

Interactive Grid without a table. Really?

Carsten Czarski
Consulting Member of technical Staff

Most Application Express developers already have played with the Interactive Grid component introduced in the latest version 5.1. And indeed - Interactive Grid makes it more than easy to get an editable tabular form on a table or view. In Page Designer, just drag the component onto your page, add the SQL query, make it editable in the Attributes section ... and you're done.

But Interactive Grid can do much more than making tabled editable. The data to be displayed in the raster can be freely generated with the region source SQL query - the end user inputs can be processed with custom PL/SQL code. So end users can enter data into an interactive grid from scratch - and PL/SQL code can process that data however needed.

From here, you can do almost anything: On the processing side, you are within the PL/SQL domain: You might process the data and finally store it some tables, call web services or do whatever you need. Thus interactive grid is much more than just a tabular form on a table; your application can do anything with the end user inputs.

Read in our latest community posting, how an create and configure such an interactive grid region. Check it out.