Study With Rafiq

My Sample Table.   CREATE TABLE "TEST_YOUR_TABLE"     ( "ID" NUMBER,  "PRODUCT_NAME" VARCHAR2(100),  "PRICE" NUMBER,  "DISCOUNT" NUMBER,  "TOTAL" NUMBER,  PRIMARY KEY ("ID…

Note : You need two grid regions          1. Main Grid Region          2. Modal  Grid   Region for Data Selection  Step: 1 ===== Select the Main Grid Region, then Create  Custom    Button. Grid Static ID:  detailsid So, Go to Region --> Attribute…

-- Create object type create or replace TYPE TYP_SIMPLE_ORDER AS OBJECT (     ANIMAL_ID       NUMBER,     SUPPLIER_ID    NUMBER,     ANIMAL_TYPE   VARCHAR2(20),     BUYING_PRICE  NUMBER,     STATUS             VARCHAR2(20) ); -- Create table type C…

Go to Page 0: Global Page   Create Page Load Dynamic Action: Action: JavaScript Code: $('#t_Body_nav #t_TreeNav').on('click', 'ul li.a-TreeView-node div.a-TreeView-content', function(){    $(this).prev('span.a-TreeView-tog…

SELECT COLUMN_1, COLUMN_2, case when STATUS=1 then    '<span style="font-size:12px;letter-spacing: .3px;display: inline-block;padding: .4rem .66666667rem;font-size: 89%;     font-weight: 500;     line-height: 1;     text-align: center; …

Step 1: ===== Create Interactive Report. SQL Query: Select column_1, column_2, column_3, '<a href="'||APEX_UTIL.PREPARE_URL('javascript:void(0)') ||'"data-id='|| PK_ID ||'><span class=" RevApp clic…

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 …