Showing posts from October, 2024
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
