Sydney Nursesynuora.hashnode.dev·Jan 9, 2025APEX: Quick Tip when using SQLcl 24.3 Projects for Database Application CI/CDIf you’re reading this, you were just as excited as I was to see SQLcl release 24.3 and its Database Application CI/CD tooling from Oracle. After the announcements, the posts on getting started by Dan McGhan [An Overview of the Oracle SQLcl Projects ...1 like·101 readsApex
Karla Cornejotoshareapex.hashnode.dev·Dec 27, 2024Tips Parte 3: El Camino Hacia la Modernización: Adaptación y Capacitación en la Transición de Oracle Forms a Oracle APEXEn el mundo tecnológico actual, la modernización de aplicaciones no es solo una necesidad, sino una oportunidad para mejorar procesos y ofrecer experiencias superiores a los usuarios finales. Uno de los ejemplos más comunes es la transición de Oracle...94 readsApex
Karla Cornejotoshareapex.hashnode.dev·Nov 29, 2024Tips Parte 2: Migrar Oracle Forms a Oracle APEXEn el ámbito tecnológico, uno de los desafíos más significativos es la migración de Oracle Forms a Oracle APEX. Este proceso puede complicarse especialmente cuando trabajamos con formularios complejos, como aquellos que tienen múltiples dependencias ...150 readsApex
Karla Cornejotoshareapex.hashnode.dev·Oct 25, 2024Tips: Migrar Oracle Forms a Oracle APEXMuchos enfrentamos grandes desafíos en el ámbito tecnológico, y uno de ellos es la migración de Oracle Forms a Oracle APEX. A menudo nos encontramos con formularios de complejidad media a alta, incluyendo formularios tipo TAB, y surge la pregunta: ¿C...278 readsformstoApex
Dominik Grabińskidgrabinski.hashnode.dev·Oct 16, 2024DTaTiA#2 - Dominik's Tips and Tricks in APEX#2: Freeze columns in Interactive Report #JoelKallmanDayHave you wondered how to freeze columns in Interactive Report in APEX? In Interactive Grid it's no problem, you use the snowflake icon: When it comes to Classic Report, there is also a solution, a plugin written by a colleague from work (great work ...1 like·186 readsoralce
Harsh Vermaforcedev.hashnode.dev·Jul 29, 2024Simplifying Polymorphic Queries in SOQL with the TYPEOF OperatorIn Salesforce Object Query Language (SOQL), polymorphic relationships enable a field to reference multiple types of records. To handle these dynamic references effectively, SOQL provides the 'TYPEOF' operator, allowing you to specify different fields...SOQL queries
Karla Cornejotoshareapex.hashnode.dev·Jun 24, 2024Tips: Interactive Grid - Saltar celdas en modo lectura.Muchas veces tenemos Grillas interactivas o Interactive Grid, en donde el usuario necesita ingresar información de una manera ágil y rápida. Para esto es importante darle las facilidades y solo fijarse en los campos en donde debe de ingresar datos. E...64 readsApex
Joe Kerrjkerr.hashnode.dev·Jun 3, 2024Guide to IG Select Lists: Important ConsiderationsContext: APEX Interactive Grid (IG) columns of type “Select List” with a large list of return values and/or many IG rows reduce performance and consume more memory. The cause is APEX takes time to populate all the column’s possible Select List value...1 like·173 reads#oracle-apex
Rutvik Prajapatirutvikprajapati.hashnode.dev·May 20, 2024Deep Linking in Oracle APEXThere are times when we need to send users a direct link to a specific page, such as an interactive report, via email or users may also want to bookmark certain pages for easy access after logging in. When a user clicks on this type of URL and is not...408 readsorclapex
Ender Polanco Rivasepolanco.dev·Apr 26, 2024"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 ...934 readsApex
