Posts

SQL: Loading Flat files without SQL*Loader

Oracle Apex: Passing variables to pages - be aware of session state

Oracle Apex: Opening a URL in a new window, from an interactive report

Oracle SQL: Comma-Delimited values using DBMS_UTILITY.comma_to_table

SQL: Sending data through a URL

ORacle SQL: Removing HTML Tags

Oracle SQL: Converting Long to VARCHAR2

Oracle BI Publishing: Emailing without attachments (via PL/SQL Package)

Oracle Apex 5.0 Plugins

Oracle Apex: dynamically display sum based on checkbox

Simple SQL to calculate business days between two dates

Splitting Delimited String Into Individual Rows

Changing individual cell colours in an Apex interactive Report

Changing an individual field colour in Apex

Locking Down Interactive Reports (Hiding the highlight rule)

Pivot Queries

Using SQL to work with JSON and how to diagnose issues