Jenkins Pipeline: Loop Multiple Databases
Here is an example for using Jenkins to loop through multiple Oracle databases (pluggable databases in this case), and execute
Read more
Oracle Tools
OCI CLI: Query By Tags
Tagging your resources is a must. Not only for billing purposes, but also for staying organized and knowing who to
Read more
OCI Command Line Interface (CLI) Basics
The OCI Command Line Interface (CLI), is a Python-based command line interpreter, that lets you interact with the Oracle Cloud
Read moreSQL Developer SSH connection
If you have to access databases that can only be reached through SSH connections, you can configure SQL Developer (4.1)
Read moreSQLd360 v3 now available, new features and (hopefully) less bugs!
SQLd360 v3 now available, new features and (hopefully) less bugs!.
Read moreMeet “edb360”: a free tool that provides a 360-degree view of an Oracle database
Meet "edb360": a free tool that provides a 360-degree view of an Oracle database.
Read moreExcel Style Row Numbering in SQL
Here is a trick to change your rownumbering (or any other sequential numbering) to the way Excel names their columns.
Read moreConfiguring Apex Listener Version 2
“Where is the listenerConfigure page?” That seems to be a common question when people attempt to deploy the Apex Listener
Read moreApex: Accessing Tabular Form Column Values
I created a tabular report on a table and needed to write some custom code that does some DML based
Read moreQDT: Escape from Alcatraz
Quick Datapump Trick Using the expdp/impdp datapump utilities on Unix/Linux can be a bit tricky when it comes to formulating
Read more