Getting Data from Oracle into Excel using Python and Pandas The storm has arrived. The lightning has struck and my data is lurching toward Excel...via pandas

Enable yum package installations in the Oracle Database App Development VM Virtualbox appliance There was a time when installing the latest version of Oracle on a laptop was rather time-consuming and fiddly.These days however, you can spin up an Oracle database playground in minutes using…

The Hitchhiker’s Guide to connecting to Oracle from Python Aliens are among us.If you want proof, just try getting a minor software upgrade applied to a server in a large organisation and you will be sure to run into a level of bureaucracy that can only have been conceived by Vogons.In this post,…

Setting up an Oracle Wallet on a Database Server running Linux When it comes to allowing os scripts to connect to Oracle without exposing the database password, Oracle Wallet is an effective solution.Whilst I've looked at this previously, I thought it would be useful to reproduce the steps…

Are your bash scripts an eloquent expression of function, a haiku plucked effortlessly from the top row of the keyboard ? No, mine aren't either, but here's one that'll help you auto-synch passwords in Linux when you haven't got any fancy tools or privileges.

Gafferbot – All Systems Meh ! The latest installment in myongoing struggle with Artificial Intelligence on the battle ground of Fantasy Football.

"I DON'T NEED YOU TO FUCKING REWRITE WHAT I'VE JUST WRITTEN!"

I have just posted a new blog discussing AI and AI for Oracle Security - www.petefinnigan.com/weblog/archi... - #oracleace #sym_42 #ukoug #ai #UKOUGDiscover25 #OracleCommunity #JoelKallmanDay #oracle #database #AI

DST diffs across the pond www.kibeha.dk/2025/10/dst-... #JoelKallmanDay

Apart from all the buzz around the "release" of 26ai, Today is also #joelkallmanday , Coordinated by @oraclebase.bsky.social, our community blogs in with that hashtag to remember Joel ... pdvfirstblog.blogspot.com/2025/10/simp...

Is SYSDATE Deterministic? #JoelKallmanDay No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement. www.salvis.com/blog/2025/10...

Creating APEX report with rolling set of columns #JoelKallmanDay The last several years I've participated in the Joel Kallman Day tributes with articles about SQL and PL/SQL. While there are no requirements for article topics, this year I wanted to contribute something within the framework Joel…

#joelkallmanday We tend to forget that troubleshooting is mainly just about Clear and Calm thinking.. pdvfirstblog.blogspot.com/2025/10/simp...

Fixing data faux pas with flashback table #JoelKallmanDay Triggered by traumatic DML errors ? Well, here's one flashback you won't mind having...

Getting Oracle to Create List Partitions automatically I recently inherited the support of an application that had been written on Oracle 11g. One of the maintenance tasks was to create a new set of partitions every so often so that records with a new value in the list partition key could be…

Using DBMS_OUTPUT in utPLSQL tests for procedures that don’t perform DML This post explores how you can unit test PL/SQL procedures that do not write to the database (other than the log table) by capturing dbms_output statements for use in a utPLSQL expectation. But first, a news flash Steven…

The Gafferbot Supremacy – why a Goldfish Memory and inability to count are no barrier to Fantasy Football Success The latest instalment in the existential battle for the future of Software Engineering...well...Fantasy Football bragging rights.

I would buy this album in a heartbeat (@fakemusic_br instagram) #funk #acdc

Oracle External Tables and really really long lines One of the things I like about External Tables is that you can use them to read a file on the Database Server OS without having to leave the comfort of the database itself.Provided you have permissions on a Directory Object pointing to the…

GafferBot – a journey into AI through the medium of Fantasy Football The AI / Fantasy Football experiment you didn't know you needed ! The bolt has gone in, the lightning has struck, and GafferBot is lurching toward Game Week 1 as manager of Artificial Idiot. What could possibly go wrong ?

Passwordless connection to a Linux server using SSH It seems that the 90s are back in fashion.Not only are Oasis currently making headlines, but England's Women have just won a penalty shootout which featured Lucy Bronze chanelling 1996-vintage Stuart Pearce.SSH also originates from the 90s, but…

User Defined Extensions in SQLDeveloper Classic – something you can’t do in VSCode (yet) After 20-odd years of making my job that little bit easier, SQLDeveloper Classic still isn't quite ready for the Recycle Bin of history.

Setting up a Local Only SMTP server in Ubuntu A stumble through how to get your bash scripts to send mails to your os user account on Ubuntu.

Fibonacci’s favourite IPL Team and the difference between ROW_NUMBER and RANK Analytic Functions This post is really a note-to-self on the differences between the RANK and ROW_NUMBER analytic functions in Oracle SQL and why you don't need to fiddle about with the order by clause of ROW_NUMBER to…

Backing Up your Linux Desktop to Google Drive using Deja Dup on Ubuntu Let's face it, ensuring that you have regular backups of your home computer to a remote location can seem like a bit of a chore…right up to the time when you've managed to lose your data and need a fast and reliable way to get…

Teddy's impression of a baby seal.

Darth Charlotte #Thetraitors

Nice to see Slipknot getting some exposure on the Traitors.

Accessing USB Storage attached to a Home Router from Ubuntu What do you do if you have no money but you do have a home network, a USB Thumb Drive and some time on your hands ? No. Not that...

Generating a CSV file with a SQL_SCRIPT Scheduler Job Need to generate a CSV from your Oracle Data Warehouse ? Do you think zebras belong in the wild and not in a data centre ? Read on...

Setting up a Credential for use in SQL_SCRIPT jobs without using the Oracle os user The SQL_SCRIPT job offers the facility to run SQL*Plus from the comfort of your own database, provided you have a Credential for an OS user on the database server. Here's how to setup a suitable user from scratch,…

Oracle DBMS_SCHEDULER – Getting in a tangle with Time Zones DBMS_SCHEDULER's slightly arcane but extremely flexible calendaring syntax allows myriad ways to determine when a batch job should run .However, there is a limitation when it comes to specifying which time zone should be used by the…

Skippy – Displaying log messages using DBMS_OUTPUT Everyone's favourite marsupial-themed PL/SQL Logging framework can now output logging statements interactively, whilst still writing them to the log table.

Oracle External Tables and the External Modify Clause mikesmithers.wordpress.com/2024/06/05/o...

"The best thing about a boolean is even if you are wrong, you are only off by a bit."

For anyone old enough to remember the headline...

New year, new (slightly) bonkers idea... wp.me/pweWl-2HZ

Even Time Lords need reminding sometimes... wp.me/pweWl-2Hw

Because "Hello World" seemed a bit of a cliche for a first post on Bluesky... wp.me/pweWl-2GY