Study With Rafiq

User Name: Kamrul Department: NULL Designation: NULL You Must be used a Parameter when condition this--> AND (:P22035_DEPARTMENT  IS NULL OR   DEPT   =:P22035_DEPARTMENT)  AND (:P22035_DESIGNATION IS NULL OR    DESIG =:P22035_DESIGNATION)

create or replace function         GET_EXPENSE_DTL (in_type in varchar2,in_id in number) return varchar2 is v_name varchar2(256); begin  if in_type  = 'AMOUNT' then SELECT SUM(AMOUNT) AMOUNT INTO V_NAME    from EXPENSE_DTL  where EXPENSE_MST_…

Go to the Link and Download. https://apex.oracle.com/pls/apex/f?p=64237:30 Go to Shared Components --> Plug-ins --> Create--> (Put the Download file) Create a new button and create a Dynamic action using the button. Action:  Alertify [Plug-…

In the last section, you want to generate a row in the Grid region. So you can follow the steps. Go to  Function and Global Variable Declaration : function f_add_row_last () {     var row$ ;     var region = apex . region ( 'tots' );     …

Button hover design ============= Inline CSS: ======== # btn_css {     border-color: #001317;     background-color: #00b227;     border-style: solid;     border-width: 0px 0px 3px;     box-shadow: 0 -1px 0 rgb(255 255 255 / 10%) inset;     border-ra…

Step:1 ===== Create a New Region. Type: Cards SQL Query: SELECT  1 SL, 'https://thumbs.dreamstime.com/b/colorful.jpg' ICON, 'Total Sell' TITEL, 'TK.'||TO_CHAR(SUM(PAID),'99,99,99,999')||'/-' TOTAL, APEX_PAGE.G…

Total Sum,Avg,Count Column Wise Step: 3 ===== Create Interactive Grid and SQL Query Change for Automatic Total value  show 0 . SQL Query: select ID,        RETURN_BILL,        PRODUCT_ID,        QTY,        ENTRY_BY,        ENTRY_DATE,        UPDATE…

1) Status Wise row Update & Delete off Step:1 ===== Create Region-->  Intarective Grid SQL Query: select ANIMAL_ID,       SUPPLIER_ID,       ANIMAL_TYPE,       STATUS,           CASE WHEN STATUS ='S' THEN 'X'           ELSE '…

Step:1 ==== /* Column and Button Design */ . pb-com {     background: linear-gradient(#599bb3, #408c99);     box-shadow: 0px 2px 4px -2px #276873;     color: rgb(13, 13, 13);     font-weight: 600;     width: 100% !important;     text-align: left !i…

Step:1 ===== / Button click then loading/removeLoading function loading() {   waiter = waitingPopup(); } function removeLoading() {   if (waiter) {     waiter.remove();   } } function waitingPopup() {   $("body").prepend(     '<div …

AND ( case           when :P22011_TYPE=' ALL '      then 'TRUE'                      when :P22011_TYPE=' PENDING '  then              (CASE WHEN  ( Quantity - Quantity_received ) >  0 THEN  'TRUE'  ELSE  'FALSE…

Step: 1 =====   Create Button. Name: Show_Report  Dynamic Action: Refresh_Report  Action: Execute Javascript code  Code :  apex.region(" GENERAL_REPORT_VIEW ").refresh();   Step: 2 =====   Select Report Region. Static ID:  GENERAL_REPORT…

CREATE TABLE   ZLOGINS_SESSIONS (   ZTIME               DATE                      DEFAULT SYSDATE,   ZUTIME              DATE,   SESSION_ID          VARCHAR2(100 BYTE)        DEFAULT sys_guid(),   USER_ID             VARCHAR2(100 BYTE),   MENU_CODE  …