CSV
Loading CSV Into Oracle With SQL Loader Control Files
Load a CSV into Oracle with SQL*Loader: a control file for quotes and dates, the bad and log files, exit codes, direct path and external tables.
7 min read
Topic
Oracle
PL/SQL, optimizer hints and enterprise oddities, translated into plain English for developers who inherit one.
CSV
Exporting an Oracle Query to CSV With SQLcl From the Shell
Export an Oracle query to a quoted CSV with SQLcl: set the CSV format, spool to a file, fix date and number formats, and run it from a shell script.
8 min read
JSON
Oracle JSON_TABLE for Turning Documents Into Rows Explained
How Oracle's JSON_TABLE projects a JSON document into relational rows and columns, with row paths, nested paths, ordinality, ON ERROR and ON EMPTY clauses.
7 min read
JSONGuide
JSON in SQL Server Oracle Snowflake and BigQuery Compared
How SQL Server, Oracle, Snowflake and BigQuery store, read, unpack, build and index JSON, side by side, with the null, type and size traps in each.
19 min read
Get new articles by email
We send one email when a new article is published. No spam.