Posts

Creating a Menu Popup in Oracle APEX Using Custom Attributes

-
Image
Step-by-Step: Creating a Menu Popup in Oracle APEX Using Custom Attributes Follow these steps to create a popup menu that appears when a button is clicked. Step 1: Create a List in Shared Components Go to App Builder → Shared Components → Lists Click Create Add your menu items (e.g., Home, Reports, Settings, Logout ) Save the list This list will be the source of your popup menu.   Step 2: Add a Button and List to a Page Open the page where you want the popup menu Add a Button (e.g., label it Menu ) Add a List Region (region type = List ) Link the List region to the list you created in Step 1 The list items will be displayed when the button is clicked.   Step 3: Assign a Static ID to the List Select the List Region in the Page Designer Go to Advanced → Static ID Enter a name, for example: cust The Static ID will be used to target this list in your popup. Step 4: Add a Custom Attribute to the Button Select the button you created Go to Advanced → Custom Attributes Add the fol...
Post a Comment
Read more

Creating a Functional Button in an Oracle APEX Interactive Grid

-
Image
  Let’s Create a Button That Doubles the Salary of the Selected Employee Step 1: Create an Interactive Grid Create a Blank Page Add an Interactive Grid region using your employee table or query Step 2: Set Static IDs Assign a Static ID to the Interactive Grid Assign a Static ID to the column on which the operation will be performed (for example, the SAL  column) These Static IDs will be used in JavaScript. Step 3: Add JavaScript Code Paste your JavaScript code into the Initialization JavaScript Function section of the Interactive Grid attributes. function (options)  { var  $ =  apex.jQuery ;   var  toolbarData  = $. apex.interactiveGrid.copyDefaultToolbar (),       toolbarGroup  =  toolbarData.toolbarFind ("actions3");     /* Add custom button */   toolbarGroup.controls.push({      type: "BUTTON",      action: "double-salary",      label: "...
Post a Comment
Read more

Implementing a Barcode Generator in Oracle APEX

-
Image
Steps to Implement Barcode Generation in Oracle APEX Step 1: Download the JsBarcode Library Download the JsBarcode JavaScript file from the official GitHub release page: https://github.com/lindell/JsBarcode/releases/latest/download/JsBarcode.all.min.js Step 2: Upload the JavaScript File as a Static Application File Go to Shared Components Navigate to Static Application Files Upload the downloaded JsBarcode.all.min.js file Step 3: Reference the JavaScript File in Your Page Open the target page in Page Designer Under JavaScript → File URLs , add the static file reference, for example: #APP_FILES#JsBarcode.all.min.js Step 4: Initialize JsBarcode on Page Load Add the following JavaScript code to the Execute when Page Loads section: JsBarcode(".barcode").init(); Step 5: Create a Report with Barcode SVG Create a Classic Report (or Interactive Report) and use the following SQL query: SELECT prod_name, '<svg class="barcode" jsbarcode-format=...
Post a Comment
Read more

Stripe Payment Gateway in Oracle APEX

-
Image
  Step-by-Step Guide: Stripe Payment Gateway in Oracle APEX Step 1: Create a Stripe Developer Account First, create a Stripe developer account using the official Stripe documentation link: 👉  https://docs.stripe.com/development After signing up, log in to the  Stripe Dashboard . Step 2: Get Stripe API Keys From the Stripe Dashboard: Navigate to  Developers → API Keys Copy: Publishable Key Secret Key ⚠️ Important: Keep the  Secret Key confidential . Never expose it on the client side. Step 3: Create a Blank Page in Oracle APEX Create a  Blank Page  in your Oracle APEX application Add the following page items: Text Field  – to enter the payment amount (e.g.,  P20_AMOUNT ) Button  – to submit the payment (e.g.,  Submit )                                                    Step 4: Create a...
Post a Comment
Read more