When Statistics Help with Filters

Here’s a fun little experiment (I’m using Oracle 19.0 for this). First, let’s start off by creating a couple of tables. Cool! Now that we got our tables, let’s join them in a query and look a the plan. Here’s… Read More

KUP-01005: syntax error: found “hash” (How to fix on an External Table)

In this article, I’ll be discussing how to fix the “KUP-01005: syntax error: found “hash”” error when selecting from an external table. Here’s the error in its entirety:ORA-29913: error in executing ODCIEXTTABLEOPEN calloutORA-29400: data cartridge errorKUP-00554: error encountered while parsing… Read More