Study With Rafiq

select * from (             select rank () over (partition by department_id order by salary desc) rn,             last_name, department_id, salary from employees )  where rn <= 3 =================== O R ======================= select FIRST_NAME, …

Step:1 ===== Check ( Yes ) Multiple Values. Separator- : Step:2 ===== Sql Query Where Condition: AND (instr(':'||nvl(:P489_BUYER_ID, P.BUYER_BUYER_ID)|| ':',':' ||P.BUYER_BUYER_ID||':') > 0 OR :P489_BUYER_ID IS NUL…

Function and Global Variable Declaration: function calculation(){ var qty = $('#P60_QTY').val()||0; var rate =$('#P60_RATE').val()||0; var price = parseFloat(qty).toFixed(2)*parseFloat(rate).toFixed(2); $('#P60_PRICE').val(pr…

Step: 1 ===== Create Style then Create Conditional Style select Variable  $V{REPORT_COUNT} %2==1 Step: 2 ===== Select All Fields and select Style name

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 [.!=''])?…