Blogs of the Month
Jeff Smith shares how to build a REST API that return a JSON array list of strings.
This blog begins with:
“When installed, Oracle GoldenGate (Microservices) will set up “services” that require a port number for access. For the first run of the Oracle GoldenGate Configuration Assistant (OGGCA), the assistant will create the ServiceManager (1 port) and the first deployment (5 ports). That means six ports would need to be opened on a firewall to run a single Oracle GoldenGate (Microservices) deployment. This only increases by five ports for each deployment built under a single ServiceManager.”
Maria asks, “What protects your data, especially your essential asset (contracts, property titles, account statements, etc.), from being modified or even deleted by folks who gain access to your systems legitimately or illegitimately (hackers)?”
The blog also includes this video:
Ron Ekins says, “If you followed my previous post you should already have an OCI OKE and Portworx Storage cluster running an Oracle 21c database, so before we start a quick look at the OKE cluster.”
His previous post can be found here.
Odie says, “I’ve recently been involved in some APEX development.
One of the application form had a bunch of input items whose visibility and mandatory aspects depend on the record type, and the business role of the current user.
This situation is typically handled with dynamic actions (DAs), and custom classes on items to minimize the number of DAs.
However, for this task, I chose to build an external item property matrix (in the form of an Excel file) to further minimize the amount of declarative settings in APEX.”
Dimitri Gielis says, “Today there was a question on how to export data from the Oracle Database and Oracle APEX into one Excel file with multiple sheets. Each sheet contains data from a different table.
With APEX Office Print it’s a matter of a few minutes to fulfill this request 😀”
The steps he goes on to detail are:
- Prepare your SQL statement
- Create your Excel template
- Specify the template and done!
Eric Erikson asks, “When there is an issue with Oracle EPM Cloud, one of the steps to work with Oracle support is to use the the provide feedback process to generate a UDR for the environment (which basically lets Oracle support look at the snapshot). But what if that doesn’t work? What do you do?”
In this final post, they cover creating a report showing a running total of the complete EMP table in order of HIREDATE.