Blogs of the Month
Jeff Smith shares how to build a REST API that return a JSON array list of strings.
2. Configuring Nginx on AWS EC2 for Oracle GoldenGate 21c
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.”
3. Why Oracle Implement Blockchain in the Database
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.
5. Building and Using an APEX Item Property Matrix
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.”
6. Export multiple tables to one Excel with different sheets in Oracle 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!
7. Provide Feedback Not Working with 22.04
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?”
8. Analytical SQL – Running Total – Order by without Partition By
This is the third post in a series. The first two can be found here and here.
In this final post, they cover creating a report showing a running total of the complete EMP table in order of HIREDATE.