I’ve been away a few months but here’s a new post :) I’ll be presenting here another approach for generating a hierarchical XML structure, besides the three ones already explained…| Odie's Oracle Blog
I’ve recently been involved in some APEX development. One of the application form had a bunch of input items whose visibility and mandatory aspects depend on the record type, and the business role of the current user. This situation is typically handled with dynamic actions (DAs), and custom classes on items to minimize the number … Continue reading Building and Using an APEX Item Property Matrix| Odie's Oracle Blog
As a preliminary step towards adding password encryption to ExcelGen (see previous post), I have enhanced my existing CFBF reader with file generation capabilities. And since it is not a reader anymore, I have also renamed it to “CDFManager” in my GitHub repository. /mbleron/MSUtilities/CDFManager Usage Line 7 : Creates a new file using version … Continue reading PL/SQL Generator for CFBF files| Odie's Oracle Blog
I’ve done a lot with ExcelTable lately and achieved pretty much all I wanted to do. Any ideas or enhancement requests are still welcome but I’ll now focus on a new “recreational” project : ExcelGen. Yes… Excel stuff again 😛 There are already some PL/SQL tools out there, so nothing new under the sun really, … Continue reading PL/SQL Excel File Generator| Odie's Oracle Blog
Lately, I had to deal with a timestamp value with an overly long sequence of decimal digits, coming as a string in ISO 8601 format : 1970-01-04T15:20:34.49899986153468675 The goal was to build an Oracle TIMESTAMP instance from this lexical representation, but rounded to 3 decimal places : 1970-01-04 15:20:34.499 In SQL, when we already have … Continue reading Rounding Timestamp Values with Fractional Seconds| Odie's Oracle Blog
ExcelTable now supports delimited or positional text data sources. Though this addition provides a small subset of the features available with Oracle’s buit-in external tables, it is not meant to compete with them. External tables can only read data from external files. Through ExcelTable interface, we are now able to read text content already residing … Continue reading ExcelTable 4.0 : Flat File Support| Odie's Oracle Blog
I’m currently working on adding support for delimited and positional flat files to ExcelTable. The file, residing as a CLOB inside the database, will be parsed using PL/SQL code. In its simplest, the base algorithm consists in locating field separators (and line terminators) in the input text and extracting data in between. DBMS_LOB.INSTR API may … Continue reading PL/SQL CSV Parsing : To Buffer or Not Buffer| Odie's Oracle Blog
I don’t know – or remember – if this was ever qualified as a bug or an unimplemented feature, but starting with Oracle 18c, we are now able to make static references to pipelined table functions returning an ANYDATASET instance in PL/SQL. This enhancement comes together with the release of Polymorphic Table Functions (PTF) in … Continue reading Oracle 18c : PL/SQL support for pipelined table functions returning ANYDATASET| Odie's Oracle Blog
Here’s the latest addition to ExcelTable (v3.1). We are now able to specify default values when mapping columns using the DML API. This new feature has been implemented based on Jordan Cortes’ request last October. ExcelTable will apply the default value either in the usual way (i.e. when the input value is NULL), or as … Continue reading ExcelTable 3.1 : Default Value Feature in DML API| Odie's Oracle Blog
ExcelTable (v3.0) finally supports multi-sheet queries. I’ve implemented this new feature following Mike Kutz’s suggestion last year. Function getRows, as well as related routines getCursor and loadData are now overloaded to accept both a list of sheet names or a sheet name pattern (regular expression). In order to know which data come from which sheet, … Continue reading ExcelTable 3.0 : Multi-sheet support| Odie's Oracle Blog
These days, I am looking into the latest additions to SODA in Oracle Database 18c, in particular the REST implementation available via Oracle REST Data Services (ORDS) : SODA for REST. I wrote once…| Odie's Oracle Blog
This post echoes one of my previous work on the topic, this time applied to JSON data. The idea is to build a user-defined aggregate function to automatically nest a hierarchically-ordered set of J…| Odie's Oracle Blog