APEX Keyboard Shortcuts were introduced around four years ago in version 5 and gave us a new way to navigate to different regions and even to save and run a...
APEX Keyboard Shortcuts were introduced around four years ago in version 5 and gave us a new way to navigate to different regions and even to save and run a page. Now in APEX 19.1 we have more interesting options such as, Create: Page, Create: Page as Copy and Spotlight Search. All of them work perfectly in US keyboard layout but what happens with other layouts and languages? Taking a Spanish layout keyboard as an example, from Page Designer let’s create a new page using the...
APEX Keyboard Shortcuts were introduced around four years ago in version 5 and gave us a new way to navigate to different regions and even to save and run a page. Now in APEX 19.1 we have...
Hola! Mi nombre es Mónica Godoy Millán. Recientemente me uní al equipo de Oracle APEX como Principal Product Manager y quiero aprovechar esta oportunidad para...
Hola! Mi nombre es Mónica Godoy Millán. Recientemente me uní al equipo de Oracle APEX como Principal Product Manager y quiero aprovechar esta oportunidad para presentarme, contarles un poco de mí y el rol que voy a desempeñar en Oracle. Lo primero, soy de Cali, Colombia. Una ciudad conocida como "La sucursal del Cielo" y "La capital de la salsa". Estudié Ingeniería de Sistemas y Computación y he trabajado en diferentes roles en departamentos de Tecnologías de la Información,...
Hola! Mi nombre es Mónica Godoy Millán. Recientemente me uní al equipo de Oracle APEX como Principal Product Manager y quiero aprovechar esta oportunidad para presentarme, contarles un poco de mí y el...
Oracle Application Express (APEX) is now generally available on Oracle Autonomous Database Cloud. The enormous benefits of a fully-managed and autonomous...
Oracle Application Express (APEX) is now generally available on Oracle Autonomous Database Cloud. The enormous benefits of a fully-managed and autonomous database cloud service, combined with an industry-leading low code platform to quickly develop and deploy applications, offers customers unparalleled capabilities. About Oracle APEX Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable and secure enterprise applications...
Oracle Application Express (APEX) is now generally available on Oracle Autonomous Database Cloud. The enormous benefits of a fully-managed and autonomous database cloud service, combined with an...
In the latest Application Express release 19.1, the Data Loading component in SQL Workshop has been dramatically improved. Not only CSV files, but also JSON,...
In the latest Application Express release 19.1, the Data Loading component in SQL Workshop has been dramatically improved. Not only CSV files, but also JSON, XML and XLSX files can be loaded into tables in the APEX workspace. However, some readers might already have noticed, that the new Data Loading wizard can only load into new tables. To accommodate SQL Workshop users needing to load data into existing tables, the functionality from previous APEX versions is still...
In the latest Application Express release 19.1, the Data Loading component in SQL Workshop has been dramatically improved. Not only CSV files, but also JSON, XML and XLSX files can be loaded...
by Andreea Dobre, Oracle Romania in Bucharest, and Carsten Czarski, Oracle Application Express Development team. One of the new features of Application Express...
by Andreea Dobre, Oracle Romania in Bucharest, and Carsten Czarski, Oracle Application Express Development team. One of the new features of Application Express 19.1 is the new Data Loading wizard, which already has been introduced in the Quick and Easy Data Loading with APEX 19.1 blog posting. But there is more than the new wizard in SQL Workshop - the new APEX_DATA_PARSER PL/SQL package provides a nice and easy developer interface to parse files. The APEX_DATA_PARSER...
by Andreea Dobre, Oracle Romania in Bucharest, and Carsten Czarski, Oracle Application Express Development team. One of the new features of Application Express 19.1 is the new Data Loading wizard,...
Starting with APEX 18.1, some significant changes where introduced on how APEX components (report, charts, calendar and others) get data. In earlier versions,...
Starting with APEX 18.1, some significant changes where introduced on how APEX components (report, charts, calendar and others) get data. In earlier versions, each component generated their own SQL query. That was fine as long as APEX only worked with data in the local database. However, with the requirement to support external data sources like REST (Web Source Modules) or REST Enabled SQL, components cannot generate their own SQL any more. An example: End users view an...
Starting with APEX 18.1, some significant changes where introduced on how APEX components (report, charts, calendar and others) get data. In earlier versions, each component generated their own...
by Andreea Dobre, Oracle Romania in Bucharest In the first Web Source Modules and the Interactive Grid blog post, Interactive Grid was built on top of a Web...
by Andreea Dobre, Oracle Romania in Bucharest In the first Web Source Modules and the Interactive Grid blog post, Interactive Grid was built on top of a Web Source Module by using customized PL/SQL code to process two DML operations: GET and POST. The blog posting covered the following steps: REST enabling of the EMP table using ORDS Creating Web Source Module using the REST endpoint Customize the GET and POST operations in order to retrieve data and insert new records within...
by Andreea Dobre, Oracle Romania in Bucharest In the first Web Source Modules and the Interactive Grid blog post, Interactive Grid was built on top of a Web Source Module by using customized...
Uploading XLSX files is a very common requirement these days. Application Express at this time only supports uploading CSV files out of the box. The community...
Uploading XLSX files is a very common requirement these days. Application Express at this time only supports uploading CSV files out of the box. The community provides quite a few blog postings and also plug-ins; most of these store the data into a collection, which makes it hard to parse an XLSX outside of an APEX context, e.g. in the background using a scheduler job. This blog posting shows a method to parse XLSX files with only SQL and PL/SQL. The actual work will be done...
Uploading XLSX files is a very common requirement these days. Application Express at this time only supports uploading CSV files out of the box. The community provides quite a few blog postings and...
Oracle Application Express (APEX) 18.1 is now generally available! APEX enables you to develop, design and deploy beautiful, responsive, data-driven desktop and...
Oracle Application Express (APEX) 18.1 is now generally available! APEX enables you to develop, design and deploy beautiful, responsive, data-driven desktop and mobile applications using only a browser. This release of APEX is a dramatic leap forward in both the ease of integration with remote data sources, and the easy inclusion of robust, high-quality application features.
Oracle Application Express (APEX) 18.1 is now generally available! APEX enables you to develop, design and deploy beautiful, responsive, data-driven desktop and mobile applications using only a...
