41554 blogs · [ { "id": "01a0bbee-e0a9-7010-a40e-892691c5525d", "title": "Oracle External Table Pre-processing – Soccer Super-Powers and Trojan Horses", "url": "https://mikesmithers.wordpress.com/2014/04/12/oracle-external-table-pre-processing-soccer-super-powers-and-trojan-horses/", "published_at": "2014-04-12T14:41:10+00:00" }, { "id": "01a0bbee-e0a9-7010-a40e-8926921155d3", "title": "Installing SQLDeveloper 4 on Mint and Ubuntu – Minus the Alien", "url": "https://mikesmithers.wordpress.com/2014/03/26/installing-sqldeveloper-4-on-mint-and-ubuntu-minus-the-alien/", "published_at": "2014-03-26T11:57:20+00:00" }, { "id": "01a0bbee-e0a9-7010-a40e-892692cf0712", "title": "PL/SQL Associative Arrays and why too much Rugby is bad for you", "url": "https://mikesmithers.wordpress.com/2014/03/09/plsql-associative-arrays-and-why-too-much-rugby-is-bad-for-you/", "published_at": "2014-03-09T11:34:10+00:00" }, { "id": "01a0bbee-e0a9-7010-a40e-8926933bdaef", "title": "Speed Isn’t Everything – LOG ERRORS, SAVE EXCEPTIONS and Fun in the Snow", "url": "https://mikesmithers.wordpress.com/2014/02/10/speed-isnt-everything-log-errors-save-exceptions-and-fun-in-the-snow/", "published_at": "2014-02-10T16:35:59+00:00" }, { "id": "01a0bbee-e0a9-7010-a40e-89269413bdf9", "title": "PL/SQL is faster than SQL – Just ask Mitch.", "url": "https://mikesmithers.wordpress.com/2014/01/19/plsql-is-faster-than-sql-just-ask-mitch/", "published_at": "2014-01-19T15:47:29+00:00" }, { "id": "01a0bbee-e0a9-7010-a40e-8926950ee68d", "title": "The Anti-Pattern – EAV(il) Database Design ?", "url": "https://mikesmithers.wordpress.com/2013/12/22/the-anti-pattern-eavil-database-design/", "published_at": "2013-12-22T23:32:14+00:00" }, { "id": "01a0bbee-e0a9-7010-a40e-8926954cdc9d", "title": "The Movember Ashes Curse and PL/SQL Parameters", "url": "https://mikesmithers.wordpress.com/2013/11/30/the-movember-ashes-curse-and-plsql-parameters/", "published_at": "2013-11-30T16:49:47+00:00" }, { "id": "01a0bbee-e0a9-7010-a40e-89269585b16c", "title": "Going Green with the Oracle Recyclebin", "url": "https://mikesmithers.wordpress.com/2013/11/10/going-green-with-the-oracle-recyclebin/", "published_at": "2013-11-10T16:56:16+00:00" }, { "id": "01a0bbee-e0a9-7010-a40e-8926963d8ad4", "title": "Generating an md5sum on Oracle Database LOBs – or how to organise your Holiday Snaps", "url": "https://mikesmithers.wordpress.com/2013/10/20/generating-an-md5sum-on-oracle-database-lobs-or-how-to-organise-your-holiday-snaps/", "published_at": "2013-10-20T16:22:15+00:00" }, { "id": "01a0bbee-e0a9-7010-a40e-892696965db1", "title": "How Oracle uses Space, sort of.", "url": "https://mikesmithers.wordpress.com/2013/10/12/how-oracle-uses-space-sort-of/", "published_at": "2013-10-12T19:09:02+00:00" }, { "id": "01a0bbf1-f114-7341-b895-cbb9a0e1a3d4", "title": "Re-structuring data for Hierarchical Queries – or (Tree) Walking With Big Macs", "url": "https://mikesmithers.wordpress.com/2013/09/29/re-structuring-data-for-hierarchical-queries-or-tree-walking-with-big-macs/", "published_at": "2013-09-29T16:20:33+00:00" }, { "id": "01a0bbf1-f114-7341-b895-cbb9a12b6bed", "title": "Mama Mia ! Oracle Database Password Complexity and Seventies Euro-Pop", "url": "https://mikesmithers.wordpress.com/2013/09/12/mama-mia-oracle-database-password-complexity-and-seventies-euro-pop/", "published_at": "2013-09-12T19:58:38+00:00" }, { "id": "01a0bbf1-f114-7341-b895-cbb9a1fba3de", "title": "Native Dynamic SQL – Dodgy Code and DRS", "url": "https://mikesmithers.wordpress.com/2013/08/24/native-dynamic-sql-dodgy-code-and-drs/", "published_at": "2013-08-24T14:46:23+00:00" }, { "id": "01a0bbf1-f114-7341-b895-cbb9a26a7910", "title": "Turning off Password expiration on Oracle XE and Apex", "url": "https://mikesmithers.wordpress.com/2013/07/28/turning-off-password-expiration-on-oracle-xe-and-apex/", "published_at": "2013-07-28T15:33:50+00:00" }, { "id": "01a0bbf1-f114-7341-b895-cbb9a2a3b76d", "title": "Simple Pleasures…rlwrap and SQL*Plus Command Line editing on Linux", "url": "https://mikesmithers.wordpress.com/2013/07/06/simple-pleasures-rlwrap-and-sqlplus-command-line-editing-on-linux/", "published_at": "2013-07-06T22:36:52+00:00" }, { "id": "01a0bbf1-f114-7341-b895-cbb9a2f54aa0", "title": "Oracle Float to Integer fun and Sachin Tendulkar", "url": "https://mikesmithers.wordpress.com/2013/06/23/oracle-float-to-integer-fun-and-sachin-tendulkar/", "published_at": "2013-06-23T21:44:37+00:00" }, { "id": "01a0bbf1-f114-7341-b895-cbb9a39d3701", "title": "Old Dog, New Phone – Insert into multiple tables in a single statement", "url": "https://mikesmithers.wordpress.com/2013/06/19/old-dog-new-phone-insert-into-multiple-tables-in-a-single-statement/", "published_at": "2013-06-19T17:05:56+00:00" }, { "id": "01a0bbf1-f114-7341-b895-cbb9a3dec918", "title": "An APEX Database Monitoring App for XE – Guilty GUI pleasures", "url": "https://mikesmithers.wordpress.com/2013/05/25/an-apex-database-monitoring-app-for-xe-guilty-gui-pleasures/", "published_at": "2013-05-25T23:14:47+00:00" }, { "id": "01a0bbf1-f114-7341-b895-cbb9a46b0aa2", "title": "ORA-02030 and invisible objects. The database bites back !", "url": "https://mikesmithers.wordpress.com/2013/05/02/ora-02030-and-invisible-objects-the-database-bites-back/", "published_at": "2013-05-02T13:25:51+00:00" }, { "id": "01a0bbf1-f114-7341-b895-cbb9a553f213", "title": "Customising the Oracle XE Menu in XFCE – why it’s better to be vegetarian", "url": "https://mikesmithers.wordpress.com/2013/04/13/customising-the-oracle-xe-menu-in-xfce-why-its-better-to-be-vegetarian/", "published_at": "2013-04-13T14:56:23+00:00" }, { "id": "01a0bbf4-cde4-730e-b1bb-eb7232baa70e", "title": "Facial Hair and Funky Job Titles – A Personal History of the Internet Age", "url": "https://mikesmithers.wordpress.com/2013/04/06/facial-hair-and-funky-job-titles-a-personal-history-of-the-internet-age/", "published_at": "2013-04-06T16:26:20+00:00" }, { "id": "01a0bbf4-cde4-730e-b1bb-eb72338a7b7c", "title": "How long is a (piece of) String. Cricketing Greats and the length function", "url": "https://mikesmithers.wordpress.com/2013/03/23/how-long-is-a-piece-of-string-cricketing-greats-and-the-length-function/", "published_at": "2013-03-23T20:03:10+00:00" }, { "id": "01a0bbf4-cde4-730e-b1bb-eb72344d3201", "title": "Disabling the Oracle Diagnostic and Tuning Pack APIs – If you want something done, do it yourself", "url": "https://mikesmithers.wordpress.com/2013/03/07/disabling-the-oracle-diagnostic-and-tuning-pack-apis-if-you-want-something-done-do-it-yourself/", "published_at": "2013-03-07T22:14:28+00:00" }, { "id": "01a0bbf4-cde4-730e-b1bb-eb7234c57612", "title": "SQLDeveloper and a very expensive query", "url": "https://mikesmithers.wordpress.com/2013/02/09/sqldeveloper-and-a-very-expensive-query/", "published_at": "2013-02-09T00:20:58+00:00" }, { "id": "01a0bbf4-cde4-730e-b1bb-eb72352b5232", "title": "Oracle Database Diagnostic and Tuning Packs – exactly what are you not licensed for ?", "url": "https://mikesmithers.wordpress.com/2013/01/26/oracle-database-diagnostic-and-tuning-packs-exactly-what-are-you-not-licensed-for/", "published_at": "2013-01-26T18:47:27+00:00" }, { "id": "01a0bbf4-cde4-730e-b1bb-eb7235cdb532", "title": "DBMS_FEATURE_USAGE_REPORT and The Phantom AFTER SELECT Trigger", "url": "https://mikesmithers.wordpress.com/2013/01/23/dbms_feature_usage_report-and-the-phantom-after-select-trigger/", "published_at": "2013-01-23T17:51:02+00:00" }, { "id": "01a0bbf4-cde4-730e-b1bb-eb7236ad8adb", "title": "Oracle Database Licensing for SMEs – Making a Contribution to Larry’s Yacht Fund", "url": "https://mikesmithers.wordpress.com/2012/12/28/oracle-database-licensing-for-smes-making-a-contribution-to-larrys-yacht-fund/", "published_at": "2012-12-28T14:50:31+00:00" }, { "id": "01a0bbf4-cde4-730e-b1bb-eb723765ffc5", "title": "Defaulting Null values in SQL*Loader", "url": "https://mikesmithers.wordpress.com/2012/12/27/defaulting-null-values-in-sqlloader/", "published_at": "2012-12-27T13:20:18+00:00" }, { "id": "01a0bbf4-cde4-730e-b1bb-eb72376d9835", "title": "ORACLE Transactions and Fishing on the Underground", "url": "https://mikesmithers.wordpress.com/2012/12/19/oracle-transactions-and-fishing-on-the-underground/", "published_at": "2012-12-19T21:19:48+00:00" }, { "id": "01a0bbf4-cde4-730e-b1bb-eb723788f495", "title": "Oracle Schema Differences – keeping up with the Prefix Pixie", "url": "https://mikesmithers.wordpress.com/2012/12/02/oracle-schema-differences-keeping-up-with-the-prefix-pixie/", "published_at": "2012-12-02T16:53:50+00:00" }, { "id": "01a0bbf7-bf5e-737c-9118-de1c94e9f680", "title": "Born Before Computers – fogey foibles and forsight for the humble insert", "url": "https://mikesmithers.wordpress.com/2012/10/21/born-before-computers-fogey-foibles-and-forsight-for-the-humble-insert/", "published_at": "2012-10-21T13:37:24+00:00" }, { "id": "01a0bbf7-bf5e-737c-9118-de1c956532fc", "title": "Oracle Batch Job Logging – a framework for domestic harmony", "url": "https://mikesmithers.wordpress.com/2012/10/15/oracle-batch-job-logging-a-framework-for-domestic-harmony/", "published_at": "2012-10-15T12:34:02+00:00" }, { "id": "01a0bbf7-bf5e-737c-9118-de1c96093b29", "title": "ORA-00845: MEMORY_TARGET error installing Oracle XE on Mint and Ubuntu", "url": "https://mikesmithers.wordpress.com/2012/09/25/ora-00845-memory_target-error-installing-oracle-xe-on-mint-and-ubuntu/", "published_at": "2012-09-25T19:26:37+00:00" }, { "id": "01a0bbf7-bf5e-737c-9118-de1c963f1be6", "title": "Playing with CLOBs – and a simple way of rolling back database changes", "url": "https://mikesmithers.wordpress.com/2012/09/08/playing-with-clobs-and-a-simple-way-of-rolling-back-database-changes/", "published_at": "2012-09-08T16:01:47+00:00" }, { "id": "01a0bbf7-bf5e-737c-9118-de1c964f8f2f", "title": "HTML 5 and Google Maps for the Milton Keynes Tourist Board", "url": "https://mikesmithers.wordpress.com/2012/08/25/html-5-and-google-maps-for-the-milton-keynes-tourist-board/", "published_at": "2012-08-25T12:59:12+00:00" }, { "id": "01a0bbf7-bf5e-737c-9118-de1c9733c721", "title": "Windows batch scripting and learning to love German footballers", "url": "https://mikesmithers.wordpress.com/2012/07/15/windows-batch-scripting-and-learning-to-love-german-footballers/", "published_at": "2012-07-15T19:07:47+00:00" }, { "id": "01a0bbf7-bf5e-737c-9118-de1c981d45dc", "title": "The CASE against DECODE and the Misery of Penalties", "url": "https://mikesmithers.wordpress.com/2012/07/05/the-case-against-decode-and-the-misery-of-penalties/", "published_at": "2012-07-05T22:12:46+00:00" }, { "id": "01a0bbf7-bf5e-737c-9118-de1c98ac9e3a", "title": "Time travel with fixed_date", "url": "https://mikesmithers.wordpress.com/2012/06/23/time-travel-with-fixed_date/", "published_at": "2012-06-23T16:35:39+00:00" }, { "id": "01a0bbf7-bf5e-737c-9118-de1c995f452f", "title": "Leading Zeros…the bleeding edge of TO_CHAR format masks", "url": "https://mikesmithers.wordpress.com/2012/06/20/leading-zeros-the-bleeding-edge-of-to_char-format-masks/", "published_at": "2012-06-20T20:43:22+00:00" }, { "id": "01a0bbf7-bf5e-737c-9118-de1c9a0e517e", "title": "Running a Windows Batch file from DBMS_SCHEDULER", "url": "https://mikesmithers.wordpress.com/2012/06/12/running-a-windows-batch-file-from-dbms_scheduler/", "published_at": "2012-06-12T12:34:46+00:00" }, { "id": "01a0bbfa-8c08-7028-9b94-0414ecadfe35", "title": "Council Tax and calling functions from SQL in 11g", "url": "https://mikesmithers.wordpress.com/2012/05/12/council-tax-and-calling-functions-from-sql-in-11g/", "published_at": "2012-05-12T13:51:01+00:00" }, { "id": "01a0bbfa-8c08-7028-9b94-0414ecee0c4a", "title": "Just because you’re Paranoid…", "url": "https://mikesmithers.wordpress.com/2012/05/02/just-because-youre-paranoid/", "published_at": "2012-05-02T19:37:57+00:00" }, { "id": "01a0bbfa-8c08-7028-9b94-0414ed6b0dc5", "title": "Implicit Cursors are from Venus, Explicit Cursors are from Mars", "url": "https://mikesmithers.wordpress.com/2012/04/19/implicit-cursors-are-from-venus-explicit-cursors-are-from-mars/", "published_at": "2012-04-19T21:46:15+00:00" }, { "id": "01a0bbfa-8c08-7028-9b94-0414ed8ecac1", "title": "V$SGA_TARGET_ADVICE – The Need for Speed", "url": "https://mikesmithers.wordpress.com/2012/04/09/vsga_target_advice-the-need-for-speed/", "published_at": "2012-04-09T18:16:50+00:00" }, { "id": "01a0bbfa-8c08-7028-9b94-0414edbb9ac9", "title": "APEX – Getting back to where you came from", "url": "https://mikesmithers.wordpress.com/2012/03/24/apex-getting-back-to-where-you-came-from/", "published_at": "2012-03-24T18:31:08+00:00" }, { "id": "01a0bbfa-8c08-7028-9b94-0414eeb9e163", "title": "Getting APEX to play with Ref Cursors", "url": "https://mikesmithers.wordpress.com/2012/02/22/getting-apex-to-play-with-ref-cursors/", "published_at": "2012-02-22T22:45:09+00:00" }, { "id": "01a0bbfa-8c08-7028-9b94-0414ef9fe7a4", "title": "Debbie in Linuxland", "url": "https://mikesmithers.wordpress.com/2012/02/17/debbie-in-linuxland/", "published_at": "2012-02-17T14:36:45+00:00" }, { "id": "01a0bbfa-8c08-7028-9b94-0414eff32f8f", "title": "VPN access on Mint using rdesktop", "url": "https://mikesmithers.wordpress.com/2012/02/08/vpn-access-on-mint-using-rdesktop/", "published_at": "2012-02-08T20:58:27+00:00" }, { "id": "01a0bbfa-8c08-7028-9b94-0414f0816f52", "title": "Turning off Code Completion in SQLDeveloper – a Grumpy Old Man Fights Back", "url": "https://mikesmithers.wordpress.com/2012/01/28/turning-off-code-completion-in-sqldeveloper-a-grumpy-old-man-fights-back/", "published_at": "2012-01-28T12:04:47+00:00" }, { "id": "01a0bbfa-8c08-7028-9b94-0414f16f04c1", "title": "Nested Tables – Flat-packed data in an Oracle Table", "url": "https://mikesmithers.wordpress.com/2012/01/14/nested-tables-flat-packed-data-in-an-oracle-table/", "published_at": "2012-01-14T19:01:44+00:00" }, { "id": "01a0bbfe-974d-7175-a4e4-62e2e4c877e5", "title": "Upgrading to APEX 4.1 on XE 11g", "url": "https://mikesmithers.wordpress.com/2011/12/20/upgrading-to-apex-4-1-on-xe-11g/", "published_at": "2011-12-20T20:10:53+00:00" }, { "id": "01a0bbfe-974d-7175-a4e4-62e2e5afc9ac", "title": "Installing Oracle 11gXE on Mint and Ubuntu", "url": "https://mikesmithers.wordpress.com/2011/11/26/installing-oracle-11gxe-on-mint-and-ubuntu/", "published_at": "2011-11-26T20:00:59+00:00" }, { "id": "01a0bbfe-974d-7175-a4e4-62e2e5d279cd", "title": "Speed Dating – NLS_DATE FORMAT in Oracle", "url": "https://mikesmithers.wordpress.com/2011/11/23/speed-dating-nls_date-format-in-oracle/", "published_at": "2011-11-23T18:23:27+00:00" }, { "id": "01a0bbfe-974d-7175-a4e4-62e2e6cd1e26", "title": "Help – DBMS_SCHEDULER keeps Spamming me…and can’t tell the time either", "url": "https://mikesmithers.wordpress.com/2011/11/10/help-dbms_scheduler-keeps-spamming-me-and-cant-tell-the-time-either/", "published_at": "2011-11-10T21:12:20+00:00" }, { "id": "01a0bbfe-974d-7175-a4e4-62e2e6d22eff", "title": "Oracle SQL and PL/SQL Coding Standards – Cat Herding for Dummies", "url": "https://mikesmithers.wordpress.com/2011/10/22/oracle-sql-and-plsql-coding-standards-%e2%80%93-cat-herding-for-dummies/", "published_at": "2011-10-22T11:54:55+00:00" }, { "id": "01a0bbfe-974d-7175-a4e4-62e2e7250e63", "title": "Anchored Declarations and the Brownie Point Economy", "url": "https://mikesmithers.wordpress.com/2011/10/03/anchored-declarations-and-the-brownie-point-economy/", "published_at": "2011-10-03T17:52:18+00:00" }, { "id": "01a0bbfe-974d-7175-a4e4-62e2e817d811", "title": "ROWNUM, Random updates and the Alert Log – A trip down Memory Lane", "url": "https://mikesmithers.wordpress.com/2011/09/19/rownum-random-updates-and-the-alert-log-%e2%80%93-a-trip-down-memory-lane/", "published_at": "2011-09-19T19:02:38+00:00" }, { "id": "01a0bbfe-974d-7175-a4e4-62e2e8c02a99", "title": "Oracle External Tables or What I did on my Holidays", "url": "https://mikesmithers.wordpress.com/2011/08/26/oracle-external-tables-or-what-i-did-on-my-holidays/", "published_at": "2011-08-26T02:36:55+00:00" }, { "id": "01a0bbfe-974d-7175-a4e4-62e2e956ee3d", "title": "Converting ogg file to mp3 format with Sound Converter", "url": "https://mikesmithers.wordpress.com/2011/08/11/converting-ogg-file-to-mp3-format-with-sound-converter/", "published_at": "2011-08-11T18:10:13+00:00" }, { "id": "01a0bbfe-974d-7175-a4e4-62e2e98719db", "title": "Minty Freshness", "url": "https://mikesmithers.wordpress.com/2011/08/08/minty-freshness/", "published_at": "2011-08-08T20:32:34+00:00" }, { "id": "01a0bc01-38ca-7202-873b-95abe621d962", "title": "If you can’t do it in PL/SQL, do it in SQL", "url": "https://mikesmithers.wordpress.com/2011/07/31/if-you-cant-do-it-in-plsql-do-it-in-sql/", "published_at": "2011-07-31T11:29:56+00:00" }, { "id": "01a0bc01-38ca-7202-873b-95abe6da7400", "title": "DBMS_APPLICATION_INFO – Are we nearly there yet ?", "url": "https://mikesmithers.wordpress.com/2011/07/23/dbms_application_info-%e2%80%93-are-we-nearly-there-yet/", "published_at": "2011-07-23T17:11:44+00:00" }, { "id": "01a0bc01-38ca-7202-873b-95abe76d1fcd", "title": "The Oracle Database – Where’s the “Upgrade Now” button ?", "url": "https://mikesmithers.wordpress.com/2011/07/05/the-oracle-database-%e2%80%93-wheres-the-%e2%80%9cupgrade-now%e2%80%9d-button/", "published_at": "2011-07-05T17:57:10+00:00" }, { "id": "01a0bc01-38ca-7202-873b-95abe7ff3182", "title": "PL/SQL Injection – The Doctor Will See You Now", "url": "https://mikesmithers.wordpress.com/2011/06/16/plsql-injection-the-doctor-will-see-you-now/", "published_at": "2011-06-16T10:43:41+00:00" }, { "id": "01a0bc01-38ca-7202-873b-95abe82dc110", "title": "Oracle, bind variables and SQL Injection – Keeping out unwanted guests", "url": "https://mikesmithers.wordpress.com/2011/06/07/oracle-bind-variables-and-sql-injection-keeping-out-unwanted-guests/", "published_at": "2011-06-07T08:11:11+00:00" }, { "id": "01a0bc01-38ca-7202-873b-95abe89a1624", "title": "Using Flashback for Automated Testing – a stepping-stone to World Domination", "url": "https://mikesmithers.wordpress.com/2011/05/26/using-flashback-for-automated-testing-a-stepping-stone-to-world-domination/", "published_at": "2011-05-26T19:52:12+00:00" }, { "id": "01a0bc01-38ca-7202-873b-95abe8dfcbd2", "title": "Oracle XE – Speeding up Startup and getting Nofications on the Desktop in Ubuntu", "url": "https://mikesmithers.wordpress.com/2011/05/16/oracle-xe-%e2%80%93-speeding-up-startup-and-getting-nofications-on-the-desktop-in-ubuntu/", "published_at": "2011-05-16T13:38:23+00:00" }, { "id": "01a0bc01-38ca-7202-873b-95abe9c727d1", "title": "Android Phone as a Wireless Hot-Spot", "url": "https://mikesmithers.wordpress.com/2011/05/14/android-phone-as-a-wireless-hot-spot/", "published_at": "2011-05-14T15:12:47+00:00" }, { "id": "01a0bc01-38ca-7202-873b-95abea51db29", "title": "Database Design – Denormalization, Codd and the Copa America", "url": "https://mikesmithers.wordpress.com/2011/05/11/database-design-%e2%80%93-denormalization-codd-and-the-copa-america/", "published_at": "2011-05-11T16:55:23+00:00" }, { "id": "01a0bc01-38ca-7202-873b-95abeb23f580", "title": "Installing Ubuntu on an EMachines E350 netbook", "url": "https://mikesmithers.wordpress.com/2011/05/02/installing-ubuntu-on-an-emachines-e350-netbook/", "published_at": "2011-05-02T14:44:46+00:00" }, { "id": "01a0bc03-c600-706b-b193-bb8f59496f0c", "title": "Custom Reports in PL/SQL Developer", "url": "https://mikesmithers.wordpress.com/2011/04/29/custom-reports-in-plsql-developer/", "published_at": "2011-04-29T13:48:06+00:00" }, { "id": "01a0bc03-c600-706b-b193-bb8f59aa80bb", "title": "The gedit bug with Shared Folders in VirtualBox – a Workaround", "url": "https://mikesmithers.wordpress.com/2011/04/17/the-gedit-bug-with-shared-folders-in-virtualbox-%e2%80%93-a-workaround/", "published_at": "2011-04-17T11:33:29+00:00" }, { "id": "01a0bc03-c600-706b-b193-bb8f59e59424", "title": "Top-N Queries in Oracle – SQL at the sharp-end of the season", "url": "https://mikesmithers.wordpress.com/2011/04/10/top-n-queries-in-oracle-%e2%80%93-sql-at-the-sharp-end-of-the-season/", "published_at": "2011-04-10T20:28:12+00:00" }, { "id": "01a0bc03-c600-706b-b193-bb8f5a51427d", "title": "SQLDeveloper 3.0 and the Missing Imported Connections in Ubuntu", "url": "https://mikesmithers.wordpress.com/2011/04/06/sqldeveloper-3-0-and-the-missing-imported-connections-in-ubuntu/", "published_at": "2011-04-06T20:59:36+00:00" }, { "id": "01a0bc03-c600-706b-b193-bb8f5af7a705", "title": "Oracle Instant Client on Ubuntu…with added Aliens", "url": "https://mikesmithers.wordpress.com/2011/04/03/oracle-instant-client-on-ubuntu-with-added-aliens/", "published_at": "2011-04-03T16:18:52+00:00" }, { "id": "01a0bc03-c600-706b-b193-bb8f5b79da2f", "title": "More Oracle Dating Tips – High Days and Holidays", "url": "https://mikesmithers.wordpress.com/2011/03/30/more-oracle-dating-tips-%e2%80%93-high-days-and-holidays/", "published_at": "2011-03-30T19:12:38+00:00" }, { "id": "01a0bc03-c600-706b-b193-bb8f5c76c638", "title": "Installing Ubuntu in VirtualBox on a Windows 7 Host", "url": "https://mikesmithers.wordpress.com/2011/03/23/installing-ubuntu-in-virtualbox-on-a-windows-7-host/", "published_at": "2011-03-23T21:24:46+00:00" }, { "id": "01a0bc03-c600-706b-b193-bb8f5d651eef", "title": "Reverse Engineering a Crud Matrix complete with SQLDeveloper Extension – Version 2", "url": "https://mikesmithers.wordpress.com/2011/03/12/reverse-engineering-a-crud-matrix-complete-with-sqldeveloper-extension-%e2%80%93-version-2/", "published_at": "2011-03-12T18:42:12+00:00" }, { "id": "01a0bc03-c600-706b-b193-bb8f5e34fd0f", "title": "ANSI SQL Huh, What is is good for ? Er, Outer Joins Actually", "url": "https://mikesmithers.wordpress.com/2011/03/09/ansi-sql-huh-what-is-is-good-for-er-outer-joins-actually/", "published_at": "2011-03-09T20:38:56+00:00" }, { "id": "01a0bc03-c600-706b-b193-bb8f5ec1767c", "title": "Nesting Quotes in SQL", "url": "https://mikesmithers.wordpress.com/2011/03/05/nesting-quotes-in-sql/", "published_at": "2011-03-05T20:12:06+00:00" }, { "id": "01a0bc06-67a4-7007-9680-a884ed385024", "title": "ORA-1810 and Other Dating Disasters", "url": "https://mikesmithers.wordpress.com/2011/02/22/ora-1810-and-other-dating-disasters/", "published_at": "2011-02-22T21:40:51+00:00" }, { "id": "01a0bc06-67a4-7007-9680-a884ed80f7fb", "title": "Installing PL/SQLDeveloper under Wine in Ubuntu", "url": "https://mikesmithers.wordpress.com/2011/02/19/installing-plsqldeveloper-under-wine-in-ubuntu/", "published_at": "2011-02-19T12:38:20+00:00" }, { "id": "01a0bc06-67a4-7007-9680-a884edee3dd1", "title": "Sinister Synonyms and Dependencies in Oracle", "url": "https://mikesmithers.wordpress.com/2011/02/05/sinister-synonyms-and-dependencies-in-oracle/", "published_at": "2011-02-05T17:27:05+00:00" }, { "id": "01a0bc06-67a4-7007-9680-a884ee32098f", "title": "Cumulative Total in Oracle SQL – Cricket, but not as we know it", "url": "https://mikesmithers.wordpress.com/2011/01/30/cumulative-total-in-oracle-sql-cricket-but-not-as-we-know-it/", "published_at": "2011-01-30T17:32:51+00:00" }, { "id": "01a0bc06-67a4-7007-9680-a884ee673b77", "title": "Select For Update – Picking the lock", "url": "https://mikesmithers.wordpress.com/2011/01/23/select-for-update-picking-the-lock/", "published_at": "2011-01-23T17:11:49+00:00" }, { "id": "01a0bc06-67a4-7007-9680-a884ee9ff3b5", "title": "Virtual Columns in Oracle 11g – Ashes to Ashes", "url": "https://mikesmithers.wordpress.com/2011/01/08/virtual-columns-in-oracle-11g-%e2%80%93-ashes-to-ashes/", "published_at": "2011-01-08T23:18:38+00:00" }, { "id": "01a0bc06-67a4-7007-9680-a884eee3f018", "title": "Upgrading to SQLDeveloper 3.0 on Ubuntu", "url": "https://mikesmithers.wordpress.com/2011/01/02/upgrading-to-sqldeveloper-3-0-on-ubuntu/", "published_at": "2011-01-02T18:34:24+00:00" }, { "id": "01a0bc06-67a4-7007-9680-a884ef31ce08", "title": "A Quick guide to Cygwin commands for the deprived of the DOS world", "url": "https://mikesmithers.wordpress.com/2010/12/30/a-quick-guide-to-cygwin-commands-for-the-deprived-of-the-dos-world/", "published_at": "2010-12-30T13:02:12+00:00" }, { "id": "01a0bc06-67a4-7007-9680-a884ef7f40b3", "title": "Migrating Oracle Data from Windows to Linux using DataPump", "url": "https://mikesmithers.wordpress.com/2010/12/21/migrating-oracle-data-from-windows-to-linux-using-datapump/", "published_at": "2010-12-21T18:29:52+00:00" }, { "id": "01a0bc06-67a4-7007-9680-a884f071791a", "title": "Twiddling with tar – Differential backups on Linux", "url": "https://mikesmithers.wordpress.com/2010/12/11/twiddling-with-tar-%e2%80%93-differential-backups-on-linux/", "published_at": "2010-12-11T17:55:19+00:00" }, { "id": "01a0bc08-caae-71b2-a89e-a1de92ada30b", "title": "Apache, Aliases and Zenity on Ubuntu – how to control your ego", "url": "https://mikesmithers.wordpress.com/2010/11/21/apache-aliases-and-zenity-on-ubuntu-%e2%80%93-how-to-control-your-ego/", "published_at": "2010-11-21T23:16:31+00:00" }, { "id": "01a0bc08-caae-71b2-a89e-a1de9367d913", "title": "Configuring OPAL on Ubuntu Desktop – without the Oracle Instant Client", "url": "https://mikesmithers.wordpress.com/2010/11/18/configuring-opal-on-ubuntu-desktop-%e2%80%93-without-the-oracle-instant-client/", "published_at": "2010-11-18T17:22:40+00:00" }, { "id": "01a0bc08-caae-71b2-a89e-a1de940e9fcc", "title": "PL/SQL – A Programmer’s Introduction – or Welcome to the Dark Side", "url": "https://mikesmithers.wordpress.com/2010/11/12/plsql-%e2%80%93-a-programmers-introduction-%e2%80%93-or-welcome-to-the-dark-side/", "published_at": "2010-11-12T13:56:44+00:00" }, { "id": "01a0bc08-caae-71b2-a89e-a1de94397d74", "title": "The PL/SQL Associative Array – the path to untold riches", "url": "https://mikesmithers.wordpress.com/2010/11/04/the-plsql-associative-array-%e2%80%93-the-path-to-untold-riches/", "published_at": "2010-11-04T13:48:06+00:00" }, { "id": "01a0bc08-caae-71b2-a89e-a1de94c26797", "title": "PL/SQL Arrays – The Autumn Collection", "url": "https://mikesmithers.wordpress.com/2010/10/31/plsql-arrays-%e2%80%93-the-autumn-collection/", "published_at": "2010-10-31T11:56:02+00:00" }, { "id": "01a0bc08-caae-71b2-a89e-a1de9505fa92", "title": "PLS-00364 – And you never buy me flowers !", "url": "https://mikesmithers.wordpress.com/2010/10/14/pls-00364-%e2%80%93-and-you-never-buy-me-flowers/", "published_at": "2010-10-14T18:13:27+00:00" }, { "id": "01a0bc08-caae-71b2-a89e-a1de9521485a", "title": "Zen and the Art of Shell Scripting", "url": "https://mikesmithers.wordpress.com/2010/10/10/zen-and-the-art-of-shell-scripting/", "published_at": "2010-10-10T15:59:27+00:00" }, { "id": "01a0bc08-caae-71b2-a89e-a1de957db756", "title": "UTL_FILE in PL/SQL – I/O, I/O, it’s off to work we go", "url": "https://mikesmithers.wordpress.com/2010/10/02/utl_file-in-plsql-io-io-its-off-to-work-we-go/", "published_at": "2010-10-02T10:41:22+00:00" }, { "id": "01a0bc08-caae-71b2-a89e-a1de95cefff9", "title": "Ripping Yarns – Music, Samba, Ubuntu and Various Discworld Characters", "url": "https://mikesmithers.wordpress.com/2010/09/25/ripping-yarns-%e2%80%93-music-samba-ubuntu-and-various-discworld-characters/", "published_at": "2010-09-25T21:17:24+00:00" }, { "id": "01a0bc08-caae-71b2-a89e-a1de95dc6888", "title": "Setting the Windows Path Variable for Cygwin…when you’re not allowed to", "url": "https://mikesmithers.wordpress.com/2010/09/18/setting-the-windows-path-variable-for-cygwin-when-youre-not-allowed-to/", "published_at": "2010-09-18T21:24:10+00:00" } ] posts Claim your blog

Back to mikesmithers.wordpress.com

Blog · corpus.blog/blogs/mikesmithers.wordpress.com/posts

mikesmithers.wordpress.com

mikesmithers.wordpress.com

2014

Oracle External Table Pre-processing – Soccer Super-Powers and Trojan Horses original ↗

12 Apr 2014

Installing SQLDeveloper 4 on Mint and Ubuntu – Minus the Alien original ↗

26 Mar 2014

PL/SQL Associative Arrays and why too much Rugby is bad for you original ↗

9 Mar 2014

Speed Isn’t Everything – LOG ERRORS, SAVE EXCEPTIONS and Fun in the Snow original ↗

10 Feb 2014

PL/SQL is faster than SQL – Just ask Mitch.original ↗

19 Jan 2014

2013

The Anti-Pattern – EAV(il) Database Design ?original ↗

22 Dec 2013

The Movember Ashes Curse and PL/SQL Parameters original ↗

30 Nov 2013

Going Green with the Oracle Recyclebin original ↗

10 Nov 2013

Generating an md5sum on Oracle Database LOBs – or how to organise your Holiday Snaps original ↗

20 Oct 2013

How Oracle uses Space, sort of.original ↗

12 Oct 2013

Re-structuring data for Hierarchical Queries – or (Tree) Walking With Big Macs original ↗

29 Sept 2013

Mama Mia ! Oracle Database Password Complexity and Seventies Euro-Pop original ↗

12 Sept 2013

Native Dynamic SQL – Dodgy Code and DRS original ↗

24 Aug 2013

Turning off Password expiration on Oracle XE and Apex original ↗

28 Jul 2013

Simple Pleasures…rlwrap and SQL*Plus Command Line editing on Linux original ↗

6 Jul 2013

Oracle Float to Integer fun and Sachin Tendulkar original ↗

23 Jun 2013

Old Dog, New Phone – Insert into multiple tables in a single statement original ↗

19 Jun 2013

An APEX Database Monitoring App for XE – Guilty GUI pleasures original ↗

25 May 2013

ORA-02030 and invisible objects. The database bites back !original ↗

2 May 2013

Customising the Oracle XE Menu in XFCE – why it’s better to be vegetarian original ↗

13 Apr 2013

Facial Hair and Funky Job Titles – A Personal History of the Internet Age original ↗

6 Apr 2013

How long is a (piece of) String. Cricketing Greats and the length function original ↗

23 Mar 2013

Disabling the Oracle Diagnostic and Tuning Pack APIs – If you want something done, do it yourself original ↗

7 Mar 2013

SQLDeveloper and a very expensive query original ↗

9 Feb 2013

Oracle Database Diagnostic and Tuning Packs – exactly what are you not licensed for ?original ↗

26 Jan 2013

DBMS_FEATURE_USAGE_REPORT and The Phantom AFTER SELECT Trigger original ↗

23 Jan 2013

2012

Oracle Database Licensing for SMEs – Making a Contribution to Larry’s Yacht Fund original ↗

28 Dec 2012

Defaulting Null values in SQL*Loader original ↗

27 Dec 2012

ORACLE Transactions and Fishing on the Underground original ↗

19 Dec 2012

Oracle Schema Differences – keeping up with the Prefix Pixie original ↗

2 Dec 2012

Born Before Computers – fogey foibles and forsight for the humble insert original ↗

21 Oct 2012

Oracle Batch Job Logging – a framework for domestic harmony original ↗

15 Oct 2012

ORA-00845: MEMORY_TARGET error installing Oracle XE on Mint and Ubuntu original ↗

25 Sept 2012

Playing with CLOBs – and a simple way of rolling back database changes original ↗

8 Sept 2012

HTML 5 and Google Maps for the Milton Keynes Tourist Board original ↗

25 Aug 2012

Windows batch scripting and learning to love German footballers original ↗

15 Jul 2012

The CASE against DECODE and the Misery of Penalties original ↗

5 Jul 2012

Time travel with fixed_date original ↗

23 Jun 2012

Leading Zeros…the bleeding edge of TO_CHAR format masks original ↗

20 Jun 2012

Running a Windows Batch file from DBMS_SCHEDULER original ↗

12 Jun 2012

Council Tax and calling functions from SQL in 11g original ↗

12 May 2012

Just because you’re Paranoid…original ↗

2 May 2012

Implicit Cursors are from Venus, Explicit Cursors are from Mars original ↗

19 Apr 2012

V$SGA_TARGET_ADVICE – The Need for Speed original ↗

9 Apr 2012

APEX – Getting back to where you came from original ↗

24 Mar 2012

Getting APEX to play with Ref Cursors original ↗

22 Feb 2012

Debbie in Linuxland original ↗

17 Feb 2012

VPN access on Mint using rdesktop original ↗

8 Feb 2012

Turning off Code Completion in SQLDeveloper – a Grumpy Old Man Fights Back original ↗

28 Jan 2012

Nested Tables – Flat-packed data in an Oracle Table original ↗

14 Jan 2012

2011

Upgrading to APEX 4.1 on XE 11g original ↗

20 Dec 2011

Installing Oracle 11gXE on Mint and Ubuntu original ↗

26 Nov 2011

Speed Dating – NLS_DATE FORMAT in Oracle original ↗

23 Nov 2011

Help – DBMS_SCHEDULER keeps Spamming me…and can’t tell the time either original ↗

10 Nov 2011

Oracle SQL and PL/SQL Coding Standards – Cat Herding for Dummies original ↗

22 Oct 2011

Anchored Declarations and the Brownie Point Economy original ↗

3 Oct 2011

ROWNUM, Random updates and the Alert Log – A trip down Memory Lane original ↗

19 Sept 2011

Oracle External Tables or What I did on my Holidays original ↗

26 Aug 2011

Converting ogg file to mp3 format with Sound Converter original ↗

11 Aug 2011

Minty Freshness original ↗

8 Aug 2011

If you can’t do it in PL/SQL, do it in SQL original ↗

31 Jul 2011

DBMS_APPLICATION_INFO – Are we nearly there yet ?original ↗

23 Jul 2011

The Oracle Database – Where’s the “Upgrade Now” button ?original ↗

5 Jul 2011

PL/SQL Injection – The Doctor Will See You Now original ↗

16 Jun 2011

Oracle, bind variables and SQL Injection – Keeping out unwanted guests original ↗

7 Jun 2011

Using Flashback for Automated Testing – a stepping-stone to World Domination original ↗

26 May 2011

Oracle XE – Speeding up Startup and getting Nofications on the Desktop in Ubuntu original ↗

16 May 2011

Android Phone as a Wireless Hot-Spot original ↗

14 May 2011

Database Design – Denormalization, Codd and the Copa America original ↗

11 May 2011

Installing Ubuntu on an EMachines E350 netbook original ↗

2 May 2011

Custom Reports in PL/SQL Developer original ↗

29 Apr 2011

The gedit bug with Shared Folders in VirtualBox – a Workaround original ↗

17 Apr 2011

Top-N Queries in Oracle – SQL at the sharp-end of the season original ↗

10 Apr 2011

SQLDeveloper 3.0 and the Missing Imported Connections in Ubuntu original ↗

6 Apr 2011

Oracle Instant Client on Ubuntu…with added Aliens original ↗

3 Apr 2011

More Oracle Dating Tips – High Days and Holidays original ↗

30 Mar 2011

Installing Ubuntu in VirtualBox on a Windows 7 Host original ↗

23 Mar 2011

Reverse Engineering a Crud Matrix complete with SQLDeveloper Extension – Version 2 original ↗

12 Mar 2011

ANSI SQL Huh, What is is good for ? Er, Outer Joins Actually original ↗

9 Mar 2011

Nesting Quotes in SQL original ↗

5 Mar 2011

ORA-1810 and Other Dating Disasters original ↗

22 Feb 2011

Installing PL/SQLDeveloper under Wine in Ubuntu original ↗

19 Feb 2011

Sinister Synonyms and Dependencies in Oracle original ↗

5 Feb 2011

Cumulative Total in Oracle SQL – Cricket, but not as we know it original ↗

30 Jan 2011

Select For Update – Picking the lock original ↗

23 Jan 2011

Virtual Columns in Oracle 11g – Ashes to Ashes original ↗

8 Jan 2011

Upgrading to SQLDeveloper 3.0 on Ubuntu original ↗

2 Jan 2011

2010

A Quick guide to Cygwin commands for the deprived of the DOS world original ↗

30 Dec 2010

Migrating Oracle Data from Windows to Linux using DataPump original ↗

21 Dec 2010

Twiddling with tar – Differential backups on Linux original ↗

11 Dec 2010

Apache, Aliases and Zenity on Ubuntu – how to control your ego original ↗

21 Nov 2010

Configuring OPAL on Ubuntu Desktop – without the Oracle Instant Client original ↗

18 Nov 2010

PL/SQL – A Programmer’s Introduction – or Welcome to the Dark Side original ↗

12 Nov 2010

The PL/SQL Associative Array – the path to untold riches original ↗

4 Nov 2010

PL/SQL Arrays – The Autumn Collection original ↗

31 Oct 2010

PLS-00364 – And you never buy me flowers !original ↗

14 Oct 2010

Zen and the Art of Shell Scripting original ↗

10 Oct 2010

UTL_FILE in PL/SQL – I/O, I/O, it’s off to work we go original ↗

2 Oct 2010

Ripping Yarns – Music, Samba, Ubuntu and Various Discworld Characters original ↗

25 Sept 2010

Setting the Windows Path Variable for Cygwin…when you’re not allowed to original ↗

18 Sept 2010