I want to freeze the First two columns and Last two columns in my Interactive Report. My first two columns: 1. Shop Id 2. Shop Name My Last two columns : 1. Status Code 2. Check_column ============================================= Go to Inline CSS:…
CREATE or replace function GET_SIM_REQ_APPROVED_DTL (in_type in varchar2,in_id in number) return varchar2 is v_name varchar2(256); begin if in_type = ' OPERATOR_REQ_QTY ' then select LISTAGG(RPAD(OPERATOR_NAME, 18, ' ') || ':…
First Look at the picture. I want to Data/Row Insert Predefine number-wise . ========================================== Step 1: ==== Create Two Interactive Grid Regions. 1. Predefine number Region. --- Static ID: Show_Dept 2. Predefine number …
Step:1 ==== Create two Interactive Grid Regions. My 1st Region--> Details Collection (For Insert the checkbox value) My 2nd Region--> SIM Request Of Approved List (For Checkbox Region) Step:2 ==== Function and Global Variable Declaration: // …
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)