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 more
Oracle Tools
SQL 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 moreAn AWKward look at tkprof.
Reading trough a tkprof file can be a long, arduous process. How do you find the things you’re looking for,
Read moreCalculate date with same week day.
Move dates so that the week days remain the same.
Read more