Thursday, April 18, 2019

sql query href link in oracle apex

select
a.MENU_CODE
, a.MENU_NAME as "CARD_TITLE"
, dbms_lob.getlength(IMG) as "CARD_TEXT"
,'<a href="f?p=' ||APPP_ID||':'||PAGGE_ID||':'||:APP_SESSION|| '">"Go to Apps"</a>' as "CARD_SUBTEXT"
from strerp_user_menu_info a, strerp_user_menu_detail b
where a.MENU_CODE=b.MENU_CODE
and  b.EMP_ID=:APP_USER
and  b.END_DT is  null
and  b.STATUS='E'
order by MENU_CODE

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...