Study With Rafiq

/************Insert Data into Table*************/ declare     v_has_error BOOLEAN := FALSE; begin     FOR R1 IN (             SELECT                COL.c001 AS SOLD_TO_CUSTOMER_ID,               COL.c002 AS GROUP_CODE,               COL.c003 AS…

Toad -Schedule Job Create  Go to Schedule Job: 1.        Basic Info: Write your Job Name: 2.        Schedule Info: Click the Mouse Right Button à Select Now Select the Time schedule for the run. 1.          3 .        Program Info:  At first, creat…

Step 1: ===== Create 1st Region. Name: Upload Data File Create Button: UPLOAD, SAVE & CLEAR Create Item: P13741_UPLOAD_FILE Type: File Upload --------------------------------- Create 2nd Region. Name: Upload Data View Type: Interactive Rep…

Step 1: ===== I want to show data conditionally, so set my Parameter. P11_TYPE_MST P11_TYPE_DTL P11_TYPE_ORG P11_ACTION --- this is working G for "Grant" or R for "Revoke" (Insert or Delete) Step 2: ===== Insert data into anot…

My Condition is that when "Transport Mode" is " Rental ", then "Vendor" Value is required. Step:1 ===== select  P22078_TRANSPORT_MODE Create Dynamic Action True Action:  Execute JavaScript Code Code: if ($v(" P2207…

Step:1 ===== Select Textarea Items. P22078_DELIVERY_LOCATION P22078_REMARKS Character Counter: Must be Uncheck Template: Optional - Floating Maximum Length: (as Like your database) Custom Attributes: class="expand-textarea" Step:2 ====…

Step 1: ===== Create a Static Container Region. Name:  Saler Visiting Map HTML Code: <!-- Leaflet CSS & JS --> <link rel="stylesheet" href="https://unpkg.com/leaflet/dist/leaflet.css" /> <script src="https…

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…