(Robert Crames) Just watched the video from @thatjeffsmith about SQLcl – and it is, indeed, worth the time. After looking that video, I’m pretty sure that SQLcl will replace SQL*Plus within months (if some more people ‘spread the word’).
Tag: Oracle
Managing the WINDOW_ID in Goldengate V11.2.1.0.33
(John Hallas) When we import data into the landing schema on a Dat Warehouse via Goldengate, we add 3 fields to each record detailing when and how the record got loaded.
Oracle 12c Service Broker for Pivotal Cloud Foundry
(Pas Apicella) The following example is a PCF 2.0 Service Broker written as a Spring Boot application. This is just an example and should be evolved to match a production type setup in terms oracle requirements.
Oracle Code … Not for database people ?
(connormcdonald) Jump over to the Oracle Code home page and you will see the “mission statement” of the Oracle Code conference series:
ODA X6-2M – How to create your own ACFS file system
(Patrick Roozen) In this post I will explain how to create your own ACFS file system (on the command line) that you can use to (temporarily) store data.
Demo App for REST enabled SQL
(Kris Rice) The new Oracle REST Data Services SQL over REST. How to enable that is on my last blog post here:
A Different Cause for enq: TM – contention
(Andrew Reid) Doc ID 1905174.1 on My Oracle Support looks at how to resolve this wait event.
KBHS-00600: Internal Error, Arguments [1] [kbhshtCreateDataBucket] Error During Backup To Oracle Cloud
(Zahid Anwar) When setting up Oracle Cloud Backup Service for first time and the Oracle Database Cloud Backup Module has been installed successfully using: Installing the Oracle Database Cloud Backup Module
Oracle New Version Numbering
(amitzil) Oracle is using the same numbering scheme since I’ve started working with it (7.2). The 5 number scheme with the release number, patchset and PSU is quite confusing and the post I wrote about that (here) is still very popular.
Oracle’s Newest PL/SQL Feature ‘ACCESSIBLE BY’
(David Fitzjarrell) Oracle has offered packages for a while now, but until recently it’s been difficult, if not impossible, to prevent ‘out of context’ execution of functions and procedures; in many cases package code is designed to be used within the context of the package, not as stand-alone proce
