(Anuradha Mudgal) The following are changes in Oracle Installation for Oracle Database release 19c.
Tag: Oracle
Securing Oracle scripts with a wallet
(Dan Jankowski) It’s that time of year when I try to clean up some of my bad habits from the year before. This time, it’s plain-text passwords in SQL scripts.
Splitting strings before they’re CLOBs!
(stewashton) After I tokenized two CLOBs in response to a forum question, Andy Sayer mentioned that they were probably files first. So I smacked my forehead and used external tables.
Expose Docker Container services on the Internet using the ngrok docker image
(Lucas Jellema) The challenge: you are running a service, API or web application in a Docker container, locally on your laptop or in a cloud based VM or container platform.
Understanding Mapping Optional Elements in OIC Integration
(Jan Kettenis) There are some easy to make mistakes to make when mapping messages with optional elements in OIC Integrations. This article describes how optional elements are being handled, and a way to make this work the way you want.
connection manager – what happens at startup & shutdown
(Martin Berger) Oracle Connection Manager (cman) is a great tool to create a gateway between networks which can not be connected, or filter those who can access to a service.
Finding the shortest path from Country A to Country B – using Neo4J and Node
(Lucas Jellema) Graph Databases are good at recording nodes and edges – and even more at performing queries that traverse the edges. Some challenges can be dealt with in Graph Databases far more elegantly and efficiently than for example in relational databases using traditional SQL.
Data Pump your Data to the Oracle Autonomous Database
(Jeff Smith) You have some data in an Oracle Database in your data center or laptop or docker or VirtualBox or…you get the idea.
Mystery and imagination of DELETE RETURNING INTO
(Flavio Casetta) Am I the only one who finds very odd this statement in the documentation of DELETE … RETURNING INTO?
Using SQL Translation Framework to access package variables
(stewashton) My last post had code to rewrite SELECT statements that tried to access public package variables. Here I’ll integrate the code into the SQL Translation Framework. Use this only in development environments.
