Hi guys, I am very new to Oracle Apex and wondering if someone can help me on this seemingly simple stuff - but I can't find it anywhere -_-a
I am using Oracle SSO to authenticate users before log in, and then I plan to make some pages only visible to some users whose username (xxx@oracle.com) are listed in my ADMIN table. So I will add the following condition (if exist condition) to my admin-only page:
select
Username
from ADMIN
where Username = :APP_USER
The problem is how can I get the current user's username value in my SQL query? I have tried :APP_USER, &APP_USER, and v('APP_USER') but nothing seemed to return the xxx@oracle.com that I expected. Any help will be appreciated!
Danny