Oracle Apex (NPG)

Excel file Upload

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…

Multiple Grid Region Collection data SAVE to Another Table

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…

Condition wise "Select List" Value Required by JavaScript

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…

Textarea Item Customs Design

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 ====…

HTML Map location point show

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…

Interactive Report Column to column Calculation

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

Using TYPE & FUNCTION then Showing Data set

-- 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…

Automatically navigation menu expand & collapse

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…

Load More
That is All