Skip to Main Content

Last 50 Blog Posts

  • Oracle APEX Blog [Ender Polanco Rivas]

    "Function Body returning SQL Query" with multiple queries.

    Here are a couple of things to consider when creating a report using a Function Body that returns an SQL Query as the data source and using "IF" to decide which query will be executed. "ELSE" must be present. The query in the "ELSE" condition will ...Published: Fri Apr 26th, 2024
    Ender Polanco Rivas
  • Hot off the Application Express [Matt Mulvaney]

    Review of Brookstrut Sample App in APEX 23.2

    That name, Brookstrut, seems to remind me of a very old APEX Sample App... hmm.. Upon further research, this app made an appearance as Sample Application in APEX 5.0 back in 2015. So 9 years later... The Brookstrut Sample App makes another appearance...Published: Thu Apr 25th, 2024
    Matt Mulvaney
  • Dive Into APEX [Steve Muench]

    Enabling Debug on APEX Builder

    When reporting a problem in the forums or in an Oracle Support ticket, if that problem occurs in the APEX Builder itself, the first instinct is to report the error message received. For example, "I'm getting Providing additional context about where that error occurs can greatly help members of the APEX community to diagnose what might be happening. Often you can obtain this extra info – for example, a PL/SQL call stack – by usinPublished: Wed Apr 24th, 2024
    Steve Muench
  • Easily and securely check user passwords for compromise [Joe Kerr]

    Upgrading Systems: Transitioning Legacy Data to a New System

    Context: When solutions require significant overhauls or upgrades to align with organizational needs, foster competitive differentiation, or transition to cutting-edge technology while maintaining the current system's operations, the tasks of creatin...Published: Mon Apr 22nd, 2024
    Joe Kerr
  • Thinking Anew [Adrian Png]

    Querying the Database in LangChain Style

    Staring from langchain_community version 0.0.31, Oracle introduced a new LangChain document loader that allows you to load the results of an SQL query, against an Oracle Autonomous Database (ADB), as documents that your retrieval-augmented generation (RAG) application can use for text generation tasks. In a previous article, I described how the select ai feature available in ADBs combines the use of database metadata and large-language models (LPublished: Sun Apr 21st, 2024
    Adrian Png
  • Dive Into APEX [Steve Muench]

    Flexing Fusion Apps Filters

    I enjoyed returning to the APEX Alpe Adria conference to chat with and learn from members of the APEX community. If you joined me in Maribor, thanks for your interest in extending Fusion Applications with Oracle APEX. You can download the slides from my session here. In a nutshell, using Fusion Apps business objects in APEX is now as easy as working with local tables. Fusion Apps (FA) business object REST APIs support filtering using SQL-likePublished: Fri Apr 19th, 2024
    Steve Muench
  • APEX T&T [Bruno Cardoso]

    Scrolling Columns in Interactive Reports and Interactive Grids in Oracle APEX

    Introduction I often hear from my fellow APEX developers about how it would be beneficial to have more control over the scrolling of Classic Report, Interactive Report, and Interactive Grid. There are discussions on APEX forums about this, yet we don...Published: Fri Apr 19th, 2024
    Bruno Cardoso
  • Cloud Nueva Blog (Oracle, APEX & ORDS) [Jon Dixon]

    Building Integrations with the Oracle DB APEX & ORDS - Part 1

    Introduction There are many ways to integrate data between two systems. One way to start a lively conversation / fight between two developers is to ask them how they would move some data between system A and system B. There are also many Integration ...Published: Thu Apr 18th, 2024
    Jon Dixon
  • SC's Tech-Blog [Steffen Clauß]

    Maps Region based on GeoJSON

    Aufgabe ist, eine Map Region based on GeoJSON zu erstellen.Ein einheitliches Format (RFC 7946), siehe https://geojson.org/“GeoJSON supports the following geometry types:{ "type": "Feature", "geometry": { "type": "Point", "coordinates": [125.6, 10.1] }, "properties": { "name": "Dinagat Islands" } }APEX suggeriert, dass man beim "Column Mapping" eine Spalte angeben kann, welche ein GeoJSON enthält und VARCHAR2 oPublished: Thu Apr 18th, 2024
    Steffen Clauß
  • Keep It Simple. Developer's tips. [Rafal Grzegorczyk]

    Highlights from APEX Alpe Adria 2024

    Maribor, Slovenia, welcomed IT professionals from near and far on April 12, 2024, for an enriching conference experience. Nestled in the heart of this picturesque city, we were treated to insightful presentations and the charm of Maribor's captivatin...Published: Wed Apr 17th, 2024
    Rafal Grzegorczyk
  • APEX T&T [Bruno Cardoso]

    Simplifying Log Recording in Oracle Databases

    Introduction In complex IT environments, especially those utilizing robust database management systems like Oracle, effective log recording is crucial. Logs are not only essential records for maintenance and troubleshooting but are also fundamental f...Published: Mon Apr 15th, 2024
    Bruno Cardoso
  • Philipp Hartenfeller Blog [Philipp Hartenfeller]

    How to add global application search to your APEX app

    Learn how to add a global search to your Oracle APEX app that searches through all your data and navigation entries. If you're looking for a more visual and interactive way to learn about the topic of this post, check out my YouTube video on the same subject.If you build large APEX applications, it will be difficult for your users to maintain an overview of what is available. Well-designed hierarchies supported by a navigation menu and breadPublished: Mon Apr 15th, 2024
    Philipp Hartenfeller
  • Snippets and Thoughts of One Oracle Developer [Jan Květina]

    APEX Alpe Adria 2024

    T Third time the charm. I love this conference, love the atmosphere, love the people. This year I have really enjoyed the networking and made few new friends. Sadly, Peter's minions were not present again, and this time nor was Peter. The APEX team was a bit more secretive than usual, but it here are some statements: APEX 24.1 will be a bit late (no news) It might and it might not bring us the 5 features promised on last Kscope (you coulPublished: Sat Apr 13th, 2024
    noreply@blogger.com (Jan Květina)
  • ThatJeffSmith, ORDS and more! [Jeff Smith]

    Having fun with SQLDev connection names 🚨🚰🌤️

    We have this feature in old school SQL Developer where you can have 'important' connections outlined with a color scheme...the connection name is also given this color. It 'works' I would say, but is it ideal? As we're re-creating our SQL Developer world inside of VS Code, we know what works, we know what people like, we know what people NEED. But, does it makes sense to do a 1:1 lift-and-shift for every fePublished: Thu Apr 11th, 2024
    thatjeffsmith
  • ThatJeffSmith, ORDS and more! [Jeff Smith]

    ORDS version 24.1 is now available, time to upgrade!

    Download ORDS ORDS 24.1 Release Notes I won't read the release notes for you, but I will summarize. Consider this your TL;DR summary! Core ORDS By 'core ORDS' - I mean the basic 'guts' of the Oracle REST Data Services software. One of changes is significant. Metadata Caching enabled by default with a default timeout of 1 second This means heavy consumers of REST APIs, esp those of the AUTOPublished: Wed Apr 10th, 2024
    thatjeffsmith
1 - 15 of 50

Authors

1 - 20 of 60