(Syed Jaffar Hussain) In this part of Migration methods to Autonomous Database (ADB) article series, we will see how to load data into ADB database using the DBMS_CLOUD package.
Community
Oracle WINDOW FUNCTION XOR SDO_GEOMETRY
(Martin Berger) Recently a friend asked me how to write a query for a SQL query which was slightly above simple SQL demo cases you can find all around.
Setting up OCI Terraform Provider
(Bobby Curtis) Over the last few months, I’ve been working to convert my skills from a core DBA/Replication specialist into a from dynamic DevOps persona.
DB2 on Docker in Double Time
(James Cockayne) Recently I was running a workshop for some customers to demonstrate various features of DB2 on the Linux platform.
Use session_context to create a ‘variable’ that lasts between batches.
(Kenneth Fisher) The other day I had a brief conversation with Itzik Ben-Gan (about|twitter) on twitter and I have to tell you the man is amazing. In a very brief exchange where he tossed a few T-SQL scripts at me, my brain hurt and I learned some really interesting stuff.
Switch as an expression in Java with Lambda-like syntax
(Rafal Borowiec) As of Java 14, the switch expression has an additional Lambda-like (case … -> labels) syntax and it can be used not only as a statement, but also as an expression that evaluates to a single value.
String Objects in JavaScript
(Vijayakumar S) In my previous article, I have explained the underlying concepts and methods and properties. In this article, we learned about String objects and String methods and Properties in JavaScript.
SQL SERVER – Fix Error: Currently This Report Does Not Have Any Data to Show, Because Default Trace Does Not Contain Relevant Information
(Pinal Dave) One of my clients of Comprehensive Database Performance Health Check recently asked me if there is a way to fix the error which they get when they try to open Schema Changes History. The error was related to Not Have Any Data to Show in the report. Let us see how we can fix that.
Install MySQL Cluster Manager ‘MCM’ using Systemd
(Ted Wennmark) For more information on how to create a service look at man systemd.service
Canonicalizing A URL By Its Individual Components In Lucee CFML 5.3.6.61
(Ben Nadel) The other day, I wrote about how the canonicalize() function decodes strings that look like HTML entities in Lucee 5. This feature of the function will inadvertently corrupt a URL that is being sanitized.