Skip to Main Content

Last 50 Blog Posts

  • Blogs on Oracle APEX [Boyd Timmerman]

    User Management in OCI Visual Builder Studio: A Step-by-Step Guide

    Lately, I have been exploring the process of setting up Oracle Cloud Infrastructure (OCI) Visual Builder Studio (VB Studio) to implement Continuous Integration and Continuous Deployment (CI/CD) with Oracle Application Express (APEX). While I plan to ...Published: Mon Feb 26th, 2024
    Boyd Timmerman
  • Hot off the Application Express [Matt Mulvaney]

    Quickly Convert Page Level LOVs to Shared Component LOVs

    For example on Page 1 you have a region called Games and a Popup LOV which has a Page Level SQL Query The Page looks like this However you have another page, Page 2, which also needs to use the same query as its List of Values. So you could do it t...Published: Sun Feb 25th, 2024
    Matt Mulvaney
  • PL/SQL Argentina [Lisandro Fernigrini]

    Actualización 23.4.1 de SQL Developer Extension for Visual Studio Code

    Tan solo unas semanas después de su presentación, la cual detallamos en el artículo "Extensión SQL Developer para Visual Studio Code", ya se encuentra disponible la primer actualización de la extensión.La misma soluciona la mayoría de los bugs reportados tanto en elForo de la Comunidad Oraclecomo en lasección de preguntas del Marketplace de Visual Studiotal como se detalla en enChangelog.La actualización se hace desdPublished: Fri Feb 23rd, 2024
    Lisandro Fernigrini
  • PL/SQL Argentina [Lisandro Fernigrini]

    LAOUC Community Tour 2024 - Fechas y Call for Papers

    Ayer se confirmaron las fechas para la serie de eventos anuales de Latin American Oracle User Community en diez ciudades de diez países de America Latina, y al mismo tiempo ya se puede participar en la Call for Papers para participar como orador en las mismas.La lista de fechas es la siguienteViernes 2 de Agosto en Ciudad de Mexico, MexicoLunes 5 de Agosto en Ciudad de Guatemala, GuatemalaMiercoles 7 de Agosto en San José, Costa RicaViernes 9 de Published: Fri Feb 23rd, 2024
    Lisandro Fernigrini
  • TM-APEX [Timo Herwix]

    Mastering Identity Lifecycle Management for OCI IAM and Azure AD

    Introduction In the previous blogpost we have walk you through how to setting up a federation between Azure AD and OCI IAM. But we ran into a small issue. 🤔 For Single Sign-On to work, the same user accounts need to be in both OCI IAM and Azure AD. ...Published: Fri Feb 23rd, 2024
    Timo Herwix
  • ThatJeffSmith, ORDS and more! [Jeff Smith]

    Oracle SQLDev extension for VS Code Update, 23.4.1

    We've just published our first update! Go get it! Big thanks to all of our early adopters who shared feedback, primarily on the Extension Marketplace Q&A and our Forums. Based on that feedback, we've identified and fixed a couple dozen bugs and opportunities for improvement. You can see the entire changelog here. But I want to call out a couple of the biggest ones. Fix #1: Default to Best Fit on the Grids DoPublished: Thu Feb 22nd, 2024
    thatjeffsmith
  • Yet another IT Consultant [Tom Lieber]

    ExportDDL.js in Oracle SQLCL

    How to run JavaScript in Oracle SQLcl with Java 17 (thatjeffsmith.com) 1) Install JDK 17 2) Install GraalVM for JDK 17 3) download Oracle GraalVM Downloads plugins gu -L install icu4j-installable-jdk-17-windows-amd64-23.0.3.jargu -L install regex-ins...Published: Thu Feb 22nd, 2024
    Tom Lieber
  • Blog - Oracle APEX Application Development [Pierre Yotti]

    Benefits of Extending ERP Systems Using APEX

    Benefits of Extending ERP Systems Using APEX One of the major use cases of Oracle APEX is extending your ERP systems. But what is the benefit of extending your ERP system using APEX? ERP systems often come with advanced features out-of-the-box, such as financial management, supply chain management, and reporting. Yet, they don't always address [...] The post <a href="https://pierre-yotti-it.com/benefits-of-extending-erp-systemPublished: Tue Feb 20th, 2024
    Pierre Yotti
  • ThatJeffSmith, ORDS and more! [Jeff Smith]

    Assign/Change Keyboard Shortcuts in SQL Dev for VS Code

    For our new VS Code Extension, Peter asks - One thing I didn't see requested in other reviews is hot key mapping. I'm used to having control-e mapped to the execute button instead of control-enter. Yes, you can do this! Keyboard shortcuts are all defined in one place, you won't find them under the VS Code Extension preferences. Open VS Code's Keyboard Shortcuts Right click in an editor and open the CoPublished: Tue Feb 20th, 2024
    thatjeffsmith
  • Keep It Simple. Developer's tips. [Rafal Grzegorczyk]

    Oracle APEX vs. Oracle Forms challenge: create a master-detail report

    Recently, I had an opportunity to create several new application features in Oracle APEX and Oracle Forms. I found myself intrigued by the differences and similarities in their approaches. This sparked the idea to share my insights through this blog....Published: Mon Feb 19th, 2024
    Rafal Grzegorczyk
  • Hot off the Application Express [Matt Mulvaney]

    Configuration of Oracle Cloud Email Delivery Service for Emailing with APEX

    There are similar blogs on this subject, however this one gives you: Up to date OCI steps, as of 2024 & APEX 23.2 A separate OCI User dedicated to email sending Separate OCI Group & Policies for Email Management Custom Domain configuration with D...Published: Mon Feb 19th, 2024
    Matt Mulvaney
  • apex_debug [Anton Nielsen]

    Monitor Page Performance in Production

    As application developers we spend most of our time in the development environment. If we are just a little bit lucky, though, the applications we develop actually find their way to a production environment. While our day to day attention is rightful...Published: Fri Feb 16th, 2024
    Anton Nielsen
  • TM-APEX [Timo Herwix]

    Single Sign-On between OCI and a third-party Identity Provider like Microsoft Azure

    Introduction In the previous blog posts, we've guided you step by step on how to set up the Authentication and Authorization process, as well as implementing Multi-Factor Authentication (MFA) or Passwordless Authentication for that extra layer of sec...Published: Fri Feb 16th, 2024
    Timo Herwix
  • Yet another IT Consultant [Tom Lieber]

    Lists and Authorization Scheme in Oracle Apex.

    I learned a lot about APEX_DICTONARY Views.. and a found a couriosity: You can do this: APPONE:Navigation Menu 2 Entries... Define on "Statistics" Entry is a Second List: This List is defined here: Thats all fine.. Yes it can be ok, that Master-Me...Published: Fri Feb 16th, 2024
    Tom Lieber
  • Cloud Nueva Blog (Oracle, APEX & ORDS) [Jon Dixon]

    5X File Loads from Object Storage with DBMS_CLOUD.COPY_DATA

    Introduction When dealing with loading large volumes of data into my APEX Apps, I typically follow this pattern: Have third-party systems post data files to OCI Object Storage. Use OCI Events to have OCI call an ORDS Service to inform the Database ...Published: Fri Feb 16th, 2024
    Jon Dixon

Authors