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…

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" ]&#…

Step-1 : Simply you create Interactive Report (My report Animals Sell Based) and Select template type as Standard. Step-2 : Create a new item (as like : P4_NOTIFICATION). Type - Hidden Step-3 : Set the Default value for that item ( P4_NOTIFICATION)  a…

If you want this. then flowing the steps Step 1 : Create classic Report (as like) select ROWID,   dbms_lob.getlength("IMAGE") CARD_TITLE,   ANIMAL_TYPE CARD_TEXT,   'Buy Price :  '||to_char(BUYING_price,'99,99,999.99') CAR…

If you are interested to add box style in Link in the following way: 1. At first go to page edit and select the Column ( as like "DEPARTMENT_ID" )    Below the code Copy and paste "Link Attributes"                            clas…