Antikyte

This Repo contains code that I've written/referenced in the blog.

The contents are :

• dbms_scheduler_background_job - a template script for running a background scheduler job in Oracle. Original Post : Running a background job in PL/SQL

• excel_from_plsql - code used in exploring Anton Scheffer's AS_XLSX package. Original Post : Generating an Excel Report from PL/SQL using AS_XLSX

• file_compare_linux - bash script to compare two files. Original Post : Linux – Checking that two files contain the same data but in a different order – Sorted!

• forall_dml - test scripts to compare the performance of forall against other array processing methods in Oracle. Orignal Post : FORALL DML - why context isn't everything

• journal_trigger_generator - PL/SQL package to generate journal triggers for and canonicalize inserts into reference data tables. Original Post : Generating Journal Triggers with help from DBMS_UTILITY

• nurdle - fun and games with SQL pattern matching and Ref Cursors on the theme of Wordle. Original Post : The most productive code I'll write this year

• public_holidays_schedule - code to create a DBMS_SCHEDULER schedule which accounts for UK Bank Holidays. Original Post : Excluding English Public Holidays from a DBMS_SCHEDULER Schedule

• wc22_wallchart - scripts to create and populate the application referenced in : Building a Master-Detail Drill-Down with Apex

• utplsql_test_harness - an example of a test harness written using the utPLSQL framework. Original Post : Cut-and-Paste-Driven-Development - Using utPLSQL to build a test harness in Oracle

• apex_data_export - Examples of calling the APEX_DATA_EXPORT package directly from PL/SQL to generate formatted output files (mainly XLSX). Original Post : Using the APEX_DATA_EXPORT package directly from PL/SQL

• sqldeveloper_extensions - Code for custom SQLDeveloper Classic Extensions Original Post : User Defined Extensions in SQLDeveloper Classic - something you can't do in VSCode (yet)

• read_file_external_tables - create an external table to read os files. Suitable for logfiles etc. Original Post : Oracle External Tables and really really long lines

• filewatcher_run_details - see which files have been detected by the dbms_scheduler filewatchers in the database. Original Post : Freddie Starr Ate My File ! Finding out exactly what the Oracle Filewatcher is up to

• dbms_output_get_lines - example of capturing dbms_output statements in variables for use in utPLSQL unit tests. Original Post : Using DBMS_OUTPUT in utPLSQL tests for procedures that don't perform DML

• linux_password_synch - synching the password of a Linux account across multiple servers using expect and secret-tool Original Post : Linux Expectation Management - scripting password changes using expect and secret-tool

• python_to_oracle_connection - connect to an Oracle database from Python using the cx-Oracle or python-oracledb packages Original Post : The Hitchhiker's Guide to connecting to Oracle from Python

• oracle_to_excel_via_python - generate a multi-worksheet Excel workbook from data extracted from Oracle via Pandas DataFrames Original Post : Getting Data from Oracle into Excel using Python and Pandas