Access Control Entries (ACEs) control which principals (users or roles) can access different resources, primarily network services, but also Oracle Wallets – which store credentials like private keys, certificates, and other sensitive data needed for secure communication and authentication. ACEs were introduced in Oracle Database 12c and supersede the older Access Control Lists (ACLs) by … Continue reading Script for Exporting Access Control Entries (ACEs)| Paulzip's Oracle Blog
Oracle’s TO_CHAR function can convert a decimal into Roman Numerals, for example : The format model ‘FMRN‘ is made up of two parts, FM = Fill Mode, this modifier suppresses whitespace padding in the return value.RN = Roman numerals (upper case). You can use rn for lower case Roman Numerals. However, Oracle doesn’t have a … Continue reading Converting Roman Numerals to Decimal| Paulzip'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
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