Django: Using an Oracle database

This post will show you how to configure a Django application to use an Oracle database. Demo overview The goal of the Django project is to store episode information for the crime fiction television series Columbo. What you will need To build this demo I used the following: VS Code 1.5.6 Django 3.2.3 Python 3.9.1 Oracle Database […]

Oracle Apex: Passing a value from a report to a database procedure

This post explains how to pass a value from a Apex classic report to a database procedure. Following a discussion of the objective and a high level overview, the post concludes with a practical demonstration. The example used throughout the post was built using using Apex 19.1 and Oracle Database 19 but this technique should work […]

SQL Developer: ANSI/Oracle Joins toggle

The ability to switch between ANSI and Oracle style joins was introduced in SQL Developer 19.2. How to use The example will show how a query using the Oracle outer join style can be changed to use the ANSI style. Highlight the SQL statement Right click to bring up the context menu and select Refactoring […]