Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I Dynamically Show information from a database to a region?

Gareth_SmythDec 21 2022 — edited Dec 21 2022

Hello,
I would like to make a region dynamic which shows administrators from a tables in my Workspace rather than manually typing their names every time an admin is added or removed.
Here is what I have tried:
Created a sub region called "How do I get access?" Which will show all the administrators.
Changed the identification type to PL/SQL Dynamic Content.
Here is the statement I tried to run:

SELECT * FROM APEX_TEST_USER_TABLE
WHERE USER_GROUP = 'Administrator';

I get the attached error when saving and running:
image.pngThank You,
Gareth

This post has been answered by Gareth_Smyth on Dec 21 2022
Jump to Answer
Comments
Post Details
Added on Dec 21 2022
5 comments
215 views