(Marc) As a preliminary step towards adding password encryption to ExcelGen (see previous post), I have enhanced my existing CFBF reader with file generation capabilities.
Tag: Oracle
Top 10 SQL Developer Tips for 2020
(Jeff Smith) I love tips, and I love lists. I’ve written a top 10 tips post, but it was way back in 2012. And those tips are still good, but the software and my perspective have definitely changed since then.
Oracle 19c Automatic Indexing: Common Index Creation Trap (Rat Trap)
(Richard Foote) When I go to a customer site to resolve performance issues, one of the most common issues I encounter is in relation to inefficient SQL. And one of the most common causes for inefficient SQL I encounter is because of deficiencies the default manner by which the index Clustering Facto
Read only partitions
(Connor McDonald) The ability for part of a table to be read-only and other parts of the same table to allow full DML is a cool feature in the Oracle Partitioning option.
Installing Virtualbox Guest Additions for Oracle Linux 8.2
(Martin Bach) Since I can never remember how to install Virtualbox Guest Additions I thought I’d write it down. Maybe it’ll save you a few minutes; I know it will save me a lot of time 😉
Deploying Oracle Database XE 18c as container on Play With Docker (PWD)
(Matthias Hoys) Play with Docker (PWD) is a free Docker environment that you can use for up to 4 hours – you only need a web browser and a Docker account! It uses the “Docker-in-Docker” technology.
Full Recovery of Standby Database over the network
(Hemant K Chitale) Say that your Standby database is lagging behind the Primary database.
AWS ATHENA – DML QUERIES
(Anand) You can learn something new everyday, and today I learned that AWS Athena supports INSERT INTO queries.
Parse JSON data in Oracle Database using JSON_TABLE in SQL
(Nimish Garg) Recently, I got opportunity to work on JSON data in Oracle Database. We were receiving this JSON data from Cisco Webex APIs, and the JSON data was complex (nested with json array).
#780 OIC –> Netsuite Asynchronous Request Processing
(Niall Commiskey) Another feature supported by the OIC Netsuite adapter –