Oracle-related Articles

Recent Articles

  • Oracle APEX Putting an Appointment on a Calendar
    Build an Oracle APEX Calendar feature that allow users to book appointments within a corporate framework.
  • Oracle APEX Building a Appointment Calendar
    How to build an appointment calendar with Oracle APEX and pl/sql
  • Oracle APEX Timestamp with time zone
    Oracle APEX struggles a bit when you want to place a timestamp with local time zone on a page. Follow one pathway to success
  • Oracle: Summer Time & Daylight Savings Time
    Use Oracle SQL to find the 2 dates in a year when a region goes from Winter to Summer time or Daylight Savings Time to Standard Time.
  • OCI-GovCloud Migration: Sending Email
    OCI-GovCloud still have a few challenges when sending email from APEX (as of January 2024).
  • OCI-GovCloud Migration: Vanity URL for APEX
    Generating a multi-domain custom URL or Vanity URL for OCI APEX
  • Migration From AWS to OCI – GovCloud
    Migrating Oracle APEX applications to Oracle Cloud Infrastructure (OCI). Why and plan
  • OCI-GovCloud Migration: Data Pump Import
    OCI GovCloud Data pump challenges can be overcome with a non-linear approach and hoping via several steps.
  • OCI-GovCloud Migration: Copy from S3 to OCI
    We are migrating from AWS to Oracle Cloud Infrastructure (OCI) during the fall/winter of 2023. Our checklist for success involves the following: The objective during this stage of our migration involves migrating the database pump file from AWS to OCI. What Did Work This process is awkward, slow, and rather manual. As a positive, it …
  • Oracle 19 JSON Management
    Build and query JSON with Oracle 19,21, 23 with this simple cheat sheet.
  • Oracle APEX Interactive Grid Select Rows
    Preselect rows in an Oracle APEX interactive grid, then process these rows. How to use a colon separated list to select rows in a grid.
  • The 1-2-3 of Data Normalization
    Abstract In the 1960s and 1970s, Dr Edgar Codd, a British computer scientist, developed a means of reducing data duplication with in relational databases. While six “forms” of the process exist, 1-4 ought to be at every database application developer’s finger tips. Fifty, nearly sixty, years have elapsed. Not only do these guidelines still apply …
  • Selecting Font APEX from a Database Table
    Quick means of grabbing font apex from CSS text file For those of us that work databases applications from the server-side and feel less sophisticated with client-side activities, I wanted to keep an inventory of the icon available in Oracle APEX to users within standard database tables. Why would a software developer include fonts in a column? Imagine scoring with a star-based rating system, or the simplicity of thumbs up/thumbs down.
  • SQL Development in Multiple Languages
    SQL Development must work on a global platform but only if we get the settings correct to display languages correctly in our code code. When an accent grave goes bad, it looks like an acute error (that’s a bad pun).