HTML Marquee byRafiqul Islam Nayeem •June 24, 2024 Step 1: Create Region. Type: PLSQL Dynamic Content PLSQL Code: DECLARE sep VARCHAR2(20):= NULL; CURSOR data IS SELECT 'Dairy Management System.' MESSAGE FROM dual; BEGIN htp.p('<div class="marquee">…
Summery Region Grand Total by HTML Design byRafiqul Islam Nayeem •June 20, 2024 Step 1: ===== Create Region. Position: Dialog Footer Type: PLSQL Dynamic Content PLSQL Code: htp.p(' <!--div id="div_print2" align="left"-->'); HTP.P('<div id="printableArea" style="fo…
Delete from Classic / Interactive Report byRafiqul Islam Nayeem •June 19, 2024 Step 1: Create Classic / Interactive Report. Add Delete Column. '<a href="'||'javascript:pageItem1(' || APEX_ESCAPE.JS_LITERAL ( PRODUCT_ID ) || ')"><span class="edit-action" style=" le…
Show And Hide Details List from Master Data byRafiqul Islam Nayeem •May 17, 2024 Step-1: ===== Create Classic/IR Report For Master. (Department List) SQL Query : Select A.DEPARTMENT_ID, A.DEPARTMENT_NAME, NVL(B.QTY,0) QTY, A.DEPARTMENT_ID report FROM DEPARTMENTS Step-2: ===== Create Item : P9_DEPT_ID_FOR_EMP_LIST And Creat…
Report with Form create Same Page byRafiqul Islam Nayeem •May 12, 2024 Step: 1 ===== Create IR Report And Entry Form Same Page. Step: 2 ===== Select Entry Form. Appearance : Template: Inline Dialog Step: 3 ===== Create Button. (New Entry) Dynamic Action: Name : New_Department_entry Event : Click True Action…
Link Report to from/Report by java-script + HTML Expression byRafiqul Islam Nayeem •May 11, 2024 Step-1 ===== Create a IR report (Master Report). SQL Query: select XLID AS ORG, REQ_HEADER_ID, . . from Table_Name; Select REQ_HEADER_ID column. HTML Expression: <a href="javascript:void(0);" class="set-po" dat…
Dashboard And Report Show byRafiqul Islam Nayeem •May 08, 2024 Step : 1 ====== Create PL/SQL Dynamic Content. PL/SQL Code : HTP.P('<!--DOCTYPE html-->'); HTP.P('<html lang="en" dir="ltr">'); HTP.P('<head>'); HTP.P('<meta charset="U…
