Tom Lieberyaitcon.hashnode.dev·May 14, 2024Empty Table => looping Page?I have a view without Data in it: i use it in comment region a classic report has the same problemo.. This are my settings this is the result: Waiting circle: Get the Session and Query: SELECT SQL_ID FROM V$SESSION WHERE STATUS = 'ACTIVE' and u...Discuss·39 readsAPEX Implemented Correctly? YES/NO?#oracle-apex
Karla Cornejotoshareapex.hashnode.dev·May 14, 2024Cargar archivo CSV usando APEX_DATA_PARSER y Data LoadingEn este post, analizaremos cómo podemos usar el paquete APEX_DATA_PARSER usando un archivo csv. En este caso uno de mis últimos requerimientos fue el siguiente: El usuario necesitaba cargar la información de su presupuesto, almacenado en formato csv,...Discuss·60 readsApex
Bruno Cardosocardoso.hashnode.dev·May 13, 2024Importing files (XLSX, CSV, XML & JSON) to the database using Oracle APEXIntroduction In a recent project I was involved in, I was tasked with handling a data load that was to be performed by external system users. There are several interesting features in APEX and Oracle databases to assist with this type of requirement,...Discuss·280 readsdataimport
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·May 12, 2024Minifying APEX_JSON CLOB OutputFirstly a walk-through of the different modes of apex_json.initialize_clob_output For example, I have this code in a Dynamic Content Region. DECLARE l_result CLOB; c sys_refcursor; BEGIN apex_json.initialize_clob_output; open c for ...Discuss·1 like·130 readsjson
Andre Spadiniaspadini.hashnode.dev·May 10, 2024Oracle: ora.proxy_advmOBJETIVO No provisionamento do Oracle Database PaaS, o mesmo já possui uma versão de S.O. instalada e pré-configurado, a Oracle não recomenda NENHUMA atualização do S.O., a não ser que o time de engenharia da Oracle solicite tal atualização. PROCESSO...Discuss·36 readsora.proxy_advm
Richmondmachiavelli.hashnode.dev·May 9, 2024Securing SaaS Data with Oracle VPD A Comprehensive OverviewIn the realm of Software as a Service (SaaS), where businesses entrust their critical data to cloud-based applications, security is paramount. As organizations increasingly adopt cloud solutions for their operations, ensuring the confidentiality, int...Discuss·47 reads#oracle-apex
Rafal Grzegorczykrafal.hashnode.dev·May 8, 2024Open Source Liquibase tutorial - a step-by-step guide for you.Introduction Many organizations have implemented DevOps in their applications. At the same time, their database change process hasn’t evolved and is still left in the dark ages. But what if you could automate that, too? It can be done using Liquibase...Discuss·2 likes·159 readsOpen Source Liquibase & Oracle SQLcl Liquibaseliquibase
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·May 7, 2024A story about APEX Debug's advice on Deprecated FeaturesI made a small discovery whilst looking a the Customers Starter Application and decided to share some thoughts. Here we go... I have a piece of code that checks the build option status. No big deal, it works fine. The page displays No errors in th...Discuss·1 like·418 readsOracle
Karla Cornejotoshareapex.hashnode.dev·May 6, 2024Content RowContent Row es una característica en Oracle Application Express (APEX) que facilita la creación y gestión de diseños responsivos y adaptativos en las aplicaciones web desarrolladas con APEX. Básicamente, permite organizar el contenido de una página e...Discuss·3 likes·209 readscontentrow
Tom Lieberyaitcon.hashnode.dev·May 4, 2024SYNC Table doesn't Exists or not?I have learned at Apex Connect that it is possible to enable Sync table for Rest Service, so we dont need do this by our own. But i got .. already Exists if i push the Create Table Button, and i look at the SQL Workshop and this table does exists.. B...Discuss·39 readsAPEX Implemented Correctly? YES/NO?orclapex