Study With Rafiq

SELECT CASE             WHEN ROW_NUMBER ()                  OVER (PARTITION BY C.SUPPLIER_ID ORDER BY C.SUPPLIER_ID) =1                   THEN  C.SUPPLIER_NAME || '(' || C.SUPPLIER_ID || ')' ELSE NULL END                 SUPPLIER_NAME,…

For Interactive Report ================ Step-1 : Create Interactive Report --> SQL Query :  SELECT EMPLOYEE_ID,FULLNAME,F_DEPT(DEPARTMENT_ID) DEPARTMENT,BASIC_SALARY,GROSS_SALARY FROM EMPLOYEES Step-2 : You must set Static id specific column C…

Conditionally Bar Chart (SQL Code) ========================= Step-1 : Create a new page. --> Create region. Name : Conditionally Bar Chart (SQL Code) --> type : Chart --> Attributes--> Type : Bar --> Series       --> Type : SQL Qu…

Unique Validation ============ Create Validation on SUPPLIER_NAME item. Validation Name: Unique_supplier_name   Type: No Rows Returned --> SQL Query : select SUPPLIER_NAME from   SUPPLIER where  upper(SUPPLIER_NAME) = upper(:P8_SUPPLIER_NAME); --…

Go to your page design Step-1 : Select your item (my selected item "fullname") --> Advanced :     Custom Attributes :          onkeypress="fn_upper(this)"; Step-2 : Function and Global Variable Declaration : function fn_uppe…

Step-1 : Create a new page. You must be select Interactive Report. --> SQL Query : SELECT EMPLOYEE_ID,FULLNAME,F_DEPT(DEPARTMENT_ID) DEPARTMENT,BASIC_SALARY,          CASE WHEN BASIC_SALARY <= 15000 THEN 'data-style="background-color:g…

Step-1 : Create a new page and select Classic Report. --> SQL Query :  select EMPLOYEE_ID,FULLNAME,F_DEPT(DEPARTMENT_ID) DEPARTMENT,BASIC_SALARY,        case when BASIC_SALARY < 10000 then 'red'             when BASIC_SALARY between 10…

Step-1 : Create a new page and select table or SQL Query. Type : Classic report Step-2 : Create Page Load Dynamic Action --> Name : row_color --> Action : Execute javascript code --> Code : $('td[headers= "BASIC_SALARY" ]&#…

If you want Go to next item  by "Enter" press. then following the steps... Go to Page Property :  JavaScript Group :   --> Execute when Page Loads : (this code Copy to paste)    $( 'body').on('keydown', 'input, select…

If you want to delete multiple rows single click. Then you following the steps.... Step-1 : Create Blank Region  --> Type : Interactive Report --> SQL Query : Use the following code  SELECT  apex_item.hidden(01,EMPLOYEE_ID)||         apex_ite…

My Table Structure is :- CREATE TABLE USER_INFO ( ID                 NUMBER(10), --- PK ORGANISATION_ID   NUMBER(10), ---- FK FULLNAME           VARCHAR2(25), USERNAME           VARCHAR2(25), EMAIL              VARCHAR2(25), BIRTH_DATE         DATE, …