Recent Posts by Carsten Czarski

It's getting close: In about 5 weeks, the Oracle developer community will meet in Seattle for the annual ODTUG KScope conference. KScope19 will contain over 300 technical sessions, hands-on labs, "Sunday Symposiums", and (of course) networking with Oracle experts from all over the globe. The Oracle APEXdevelopment team will be there, not only with sessions about new features, but also with deep-dive sessions on existing functionality as well. So don't miss this opportunity to...

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...

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...

The latest Application Express Release 19.1 takes its support for external data sources (REST Services and REST Enabled SQL) to the next level. Forms do now support REST services and REST Enabled SQL declaratively. Thus APEX allows to create report, chart and form pages on REST services - all declarative and without manual coding. This blog posting shows, how it works. Prerequisites I: Create a table and load sample data First, we need a REST service, to create the APEX...

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...

The upcoming Application Express Release 19.1 (try it out on the Early Adopter Instance) also contains new features for the Interactive Grid component. Based on actual customer feedback, the APEX development team added some more declarative options for Interactive Grid. Tasks, which required adding Javascript code in earlier versions, are now done with a simple mouse click. That makes Interactive Grid easier to use and more maintainable. This (short) blog posting provides...

The latest APEX Early Adopter Release 19.1 introduces a lot of new functionality for forms. First, there is REST Service and REST Enabled SQL support for forms, as outlined in the Statement Of Direction. This will be covered in a separate blog posting in more detail. Today we have a look at some other, general changes to form pages in APEX 19.1. The most straightforward way to do this is to log into the Application Express 19.1 Early Adopter Instance, create a new application...

A new, improved Data Loading facility is one of the new features in Application Express 19.1. This new feature is not only a dramatic improvement of the existing CSV Data Upload utility - it also supports more file types, detects settings automatically, runs in the background and comes with a PL/SQL API, which application developers can use. This blog posting will introduces the new Data Upload facility in Application Express SQL Workshop. You can try this feature out on the...

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...