Ryan Williamsora-wtf.com·Aug 22, 2024PL/SQL Software Development Compliance by Cybersecurity FrameworksThe evolving cybersecurity landscape is driving significant changes in software development compliance and supply chain defense. Oracle APEX and PL/SQL present a unique challenge as they straddle the line between application and database, often leadi...Discussnist-800-218
Jordy Kiesebrinkjkiesebrink.hashnode.dev·Aug 20, 2024Dynamic Row Refresh with Custom Templates in Oracle APEX: A Step-by-Step GuideIntroduction In this blog post, we’ll explore how to dynamically refresh a row with custom templates in Oracle APEX without refreshing the entire region, even if you need to apply different row templates based on specific conditions. We will cover a ...DiscussJavaScript
Ryan Williamsora-wtf.com·Aug 20, 2024Best Practices for Using utPLSQL for Unit Testing, Documentation, and Reporting in Oracle DatabaseutPLSQL is a powerful unit testing framework for PL/SQL in Oracle databases. It supports a wide range of testing capabilities, including assertions, test suites, code coverage analysis, and more. Below are best practices for using utPLSQL effectively...Discussunit testing
Cristhian Cano Bogadoparaguayandev.hashnode.dev·Aug 17, 2024Navegar entre pestañas del tabs region con javascriptOracle APEX permite el uso de JavaScript que facilita la manipulación de regiones de pestañas. Esta permite realizar tareas como cambiar a una pestaña específica, obtener la pestaña activa, y mucho más. Estas funciones son útiles cuando quieres contr...Discuss·72 readsgraficos
David Ferroldavidferrol.hashnode.dev·Aug 8, 2024Oracle APEX - Set Page Items to NULLbegin apex_util.set_session_state('P1_ITEM1', null); apex_util.set_session_state('P1_ITEM2', 'some value'); end;Discuss#oracle-apex
Tomas Kucharzykkuchatom.hashnode.dev·Jul 29, 2024How to Easily Parse JSON into Oracle Database TablesIn my previous article, I described my first encounter with the new Oracle Database 23ai functionality called JSON-Relational Duality Views. It is a very useful feature, especially if you have to parse or create JSON objects in your Oracle database. ...Discuss·83 readsjson
Phil Grinhamphilgrinham.hashnode.dev·Jul 22, 2024Just Passing ThroughDatabase links have been a key feature of the Oracle database for a long time, allowing one database instance to interact with another. These "remote" databases do not have to be Oracle databases; the heterogeneous gateway allows for ODBC connectivit...Discuss·100 readsOracle
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·May 30, 2024Regex Searching APEX Apps for use of Deprecated FeaturesI wrote a story recently on deprecated APEX APIs and in there I wrote "You have to make proactive steps to resolve [deprecated APEX APIs]". So how do you spot that you're using deprecated features so that you can be proactive? The Advisor is not advi...Discuss·3 likes·108 readsorclapex
Azam Sajidaazamsajid.hashnode.dev·May 29, 2024Unlocking Efficiency in Data Analytics: The Power of Materialized Views in Oracle SQLIntroduction In the fast-paced world of data analytics, efficiency and performance are paramount. As data professionals, we often grapple with the challenge of optimizing query performance to deliver insights swiftly and accurately. One powerful yet ...Discuss·26 readsoracleapex
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·May 19, 2024Inline Instructions UX Pattern for APEXRecently I started a piece of research on Inline Application Help. I wanted to find examples of guiding the user, helping them completing the page, without being too obtrusive, annoying or taking up valuable screen area. After not too long, I found t...Discuss·8 likes·613 reads#oracle-apex