Study With Rafiq

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">…

PLSQL Dynamic Content: DECLARE     CURSOR GRN_SALES_MASTER IS         SELECT TRCODE,                TRCODES,                SERIALNO,                GRN_RLOC,                GRN_MDATE,                --- SLCODE,                FUNC_DEALER_NAME_BN  (…

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…

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…

1. Grand/Group Sum Advanced : <?sum(current-group()/ DEBIT [.!=''])?> Group Amount in Word: <?xdoxslt:toWordsAmt(sum(current-group()/ DEBIT [.!='']))?> taka only. ------------ Advanced :  <?sum( DEBIT [.!=''])?…

SELECT EMPNAME,ZONE_NAME, case when ATTN_IN IS NOT NULL then '<span class="info" style=" text-align: center; letter-spacing: .3px; display: inline-block;padding: 0.4rem 0.66666667rem;line-height: 1;padding-right: 0.6em;padding-…

Step-1: ===== Create Report Parameter Items. And Create Region PLSQL Dynamic Container. PLSQL Code : htp.p('   <!--div id="div_print2" align="left"-->');    HTP.P('<div id="printableArea" style=&quo…