Home > Software engineering >  How to add a custom table with data from the database to the application in Oracle APEX?
How to add a custom table with data from the database to the application in Oracle APEX?

Time:04-26

I need to add to an application in Oracle APEX a small module similar to static HTML but which retrieves data from a database.

That is, a customized table with data from the database.

Is it possible to do something like this in Oracle APEX?

CodePudding user response:

OK I used PL/SQL Dynamic content:

declare
begin
for rec in (select CATEGORY_TITLE from TBL_CATEGORY)
loop
htp.p('<table style="border: 2px solid #eee;">');
htp.p('<tr>');
htp.p('<td>'||'Category: '||'</td>'||'<td>'||rec.CATEGORY_TITLE||'</td>'||'<td>'||'</td>'||'<td>'||'</td>');
htp.p('</tr>');
htp.p('</table>');
htp.p('<br>');
end loop;
end;
  • Related