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;