corpus.blog
41554 blogs · [ { "id": "01a0bbc9-5e80-71cc-bf75-3ddad1757b7e", "title": "Extending the range of my Home Network Wi-fi by converting an old router into a Wireless Access Point", "url": "https://mikesmithers.wordpress.com/2019/09/02/extending-the-range-of-my-home-network-wi-fi-by-converting-an-old-router-into-a-wireless-access-point/", "published_at": "2019-09-02T13:11:31+00:00" }, { "id": "01a0bbc9-5e80-71cc-bf75-3ddad1faaf14", "title": "Changing the Hostname and IP Address on a CentOS server and re-configuring Oracle and ORDS", "url": "https://mikesmithers.wordpress.com/2019/08/13/changing-the-hostname-and-ip-address-on-a-centos-server-and-re-configuring-oracle-and-ords/", "published_at": "2019-08-13T21:04:27+00:00" }, { "id": "01a0bbc9-5e80-71cc-bf75-3ddad25ab492", "title": "VirtualBox – running a Windows 10 Guest on an Ubuntu Host", "url": "https://mikesmithers.wordpress.com/2019/08/02/virtualbox-running-a-windows-10-guest-on-an-ubuntu-host/", "published_at": "2019-08-02T15:02:15+00:00" }, { "id": "01a0bbc9-5e80-71cc-bf75-3ddad26181ea", "title": "Customizing DML in an APEX Interactive Grid", "url": "https://mikesmithers.wordpress.com/2019/07/23/customizing-dml-in-an-apex-interactive-grid/", "published_at": "2019-07-23T21:06:20+00:00" }, { "id": "01a0bbc9-5e80-71cc-bf75-3ddad26cad81", "title": "Oracle Express Edition – features new to 18cXE", "url": "https://mikesmithers.wordpress.com/2019/07/13/oracle-express-edition-features-new-to-18cxe/", "published_at": "2019-07-13T20:55:25+00:00" }, { "id": "01a0bbc9-5e80-71cc-bf75-3ddad27ddf0c", "title": "SQLcl ALIAS – because you can’t remember everything.", "url": "https://mikesmithers.wordpress.com/2019/06/25/sqlcl-alias-because-you-cant-remember-everything/", "published_at": "2019-06-25T13:47:01+00:00" }, { "id": "01a0bbc9-5e80-71cc-bf75-3ddad3340c7d", "title": "Installing the OE demo schema on 18cXE", "url": "https://mikesmithers.wordpress.com/2019/06/15/installing-the-oe-demo-schema-on-18cxe/", "published_at": "2019-06-15T18:18:02+00:00" }, { "id": "01a0bbc9-5e80-71cc-bf75-3ddad3ca2edb", "title": "Great Football Managers and Oracle Unified Auditing", "url": "https://mikesmithers.wordpress.com/2019/05/31/great-football-managers-and-oracle-unified-auditing/", "published_at": "2019-05-31T16:48:07+00:00" }, { "id": "01a0bbc9-5e80-71cc-bf75-3ddad3fb0016", "title": "ORA-01775 – Looping Chain of Synonyms and Epic Football Punditry", "url": "https://mikesmithers.wordpress.com/2019/04/30/ora-01775-looping-chain-of-synonyms-and-epic-football-punditry/", "published_at": "2019-04-30T09:59:56+00:00" }, { "id": "01a0bbc9-5e80-71cc-bf75-3ddad3fee935", "title": "Easy Listening with Datapump in the SQLDeveloper DBA Module", "url": "https://mikesmithers.wordpress.com/2019/04/01/easy-listening-with-datapump-in-the-sqldeveloper-dba-module/", "published_at": "2019-04-01T17:05:03+00:00" }, { "id": "01a0bbce-2b3d-7019-8de8-f31fd1f49f8a", "title": "Adding an item to the Ubuntu Unity Launcher", "url": "https://mikesmithers.wordpress.com/2019/03/24/adding-an-item-to-the-ubuntu-unity-launcher/", "published_at": "2019-03-24T22:20:23+00:00" }, { "id": "01a0bbce-2b3d-7019-8de8-f31fd248c71a", "title": "Installing APEX and ORDS on Oracle 18cXE on CentOS", "url": "https://mikesmithers.wordpress.com/2019/03/01/installing-apex-and-ords-on-oracle-18cxe-on-centos/", "published_at": "2019-03-01T18:06:05+00:00" }, { "id": "01a0bbce-2b3d-7019-8de8-f31fd2bb63f7", "title": "Oracle Create Schema – multiple DDL statements in a single transaction", "url": "https://mikesmithers.wordpress.com/2019/02/14/oracle-create-schema-multiple-ddl-statements-in-a-single-transaction/", "published_at": "2019-02-14T22:08:16+00:00" }, { "id": "01a0bbce-2b3d-7019-8de8-f31fd35ac14c", "title": "Pi in a time of Brexit – Remote Controlling Raspberry Pi from Ubuntu using VNC", "url": "https://mikesmithers.wordpress.com/2019/01/27/pi-in-a-time-of-brexit-remote-controlling-raspberry-pi-from-ubuntu-using-vnc/", "published_at": "2019-01-27T20:52:05+00:00" }, { "id": "01a0bbce-2b3d-7019-8de8-f31fd3d386f2", "title": "Using a Proxy User for Code Deployment in Oracle", "url": "https://mikesmithers.wordpress.com/2019/01/14/using-a-proxy-user-for-code-deployment-in-oracle/", "published_at": "2019-01-14T18:54:05+00:00" }, { "id": "01a0bbce-2b3d-7019-8de8-f31fd4b222db", "title": "Installing and Configuring Oracle 18cXE on CentOS", "url": "https://mikesmithers.wordpress.com/2019/01/03/installing-and-configuring-oracle-18cxe-on-centos/", "published_at": "2019-01-03T17:50:07+00:00" }, { "id": "01a0bbce-2b3d-7019-8de8-f31fd516d172", "title": "Debbie Saves Christmas – Database Development in a Devops Wonderland : Re-runnable DDL", "url": "https://mikesmithers.wordpress.com/2018/12/19/debbie-saves-christmas-database-development-in-a-devops-wonderland-re-runnable-ddl/", "published_at": "2018-12-19T17:45:25+00:00" }, { "id": "01a0bbce-2b3d-7019-8de8-f31fd595a50d", "title": "VirtualBox – configuring a Host-Only Network", "url": "https://mikesmithers.wordpress.com/2018/11/17/virtualbox-configuring-a-host-only-network/", "published_at": "2018-11-17T14:34:35+00:00" }, { "id": "01a0bbce-2b3d-7019-8de8-f31fd676bddc", "title": "New Dog, Old Tricks – how to save yourself some typing with sed", "url": "https://mikesmithers.wordpress.com/2018/11/04/new-dog-old-tricks-how-to-save-yourself-some-typing-with-sed/", "published_at": "2018-11-04T16:07:44+00:00" }, { "id": "01a0bbce-2b3d-7019-8de8-f31fd6df3ae0", "title": "Cocktails and Traffic Cones – party time with DVDs and Blu-Rays in Ubuntu", "url": "https://mikesmithers.wordpress.com/2018/08/29/cocktails-and-traffic-cones-party-time-with-dvds-and-blu-rays-in-ubuntu/", "published_at": "2018-08-29T19:37:01+00:00" }, { "id": "01a0bbd2-5c70-702b-9df8-5a8254cae42e", "title": "Read Only Access for providing backend support for an Oracle Application", "url": "https://mikesmithers.wordpress.com/2018/07/25/read-only-access-for-providing-backend-support-for-an-oracle-application/", "published_at": "2018-07-25T20:59:53+00:00" }, { "id": "01a0bbd2-5c70-702b-9df8-5a8255292d51", "title": "You have chosen not to trust… – Citrix Receiver and SSL error 61 on Ubuntu", "url": "https://mikesmithers.wordpress.com/2018/06/08/you-have-chosen-not-to-trust-citrix-receiver-and-ssl-error-61-on-ubuntu/", "published_at": "2018-06-08T19:01:28+00:00" }, { "id": "01a0bbd2-5c70-702b-9df8-5a8255b4e048", "title": "First Steps in SQLDeveloper Data Modeler", "url": "https://mikesmithers.wordpress.com/2018/05/30/first-steps-in-sqldeveloper-data-modeler/", "published_at": "2018-05-30T18:12:08+00:00" }, { "id": "01a0bbd2-5c70-702b-9df8-5a8255d627b4", "title": "utPLSQL 3.0 – How to have your cake and eat it", "url": "https://mikesmithers.wordpress.com/2018/04/25/utplsql-3-0-how-to-have-your-cake-and-eat-it/", "published_at": "2018-04-25T19:13:33+00:00" }, { "id": "01a0bbd2-5c70-702b-9df8-5a82562852d4", "title": "Streaming Videos with Plex on Raspberry Pi", "url": "https://mikesmithers.wordpress.com/2018/04/08/streaming-videos-with-plex-on-raspberry-pi/", "published_at": "2018-04-08T10:52:27+00:00" }, { "id": "01a0bbd2-5c70-702b-9df8-5a825722c6fb", "title": "Geeky Speed Freakery in the Wild (South) West…", "url": "https://mikesmithers.wordpress.com/2018/02/25/geeky-speed-freakery-in-the-wild-south-west/", "published_at": "2018-02-25T20:13:50+00:00" }, { "id": "01a0bbd2-5c70-702b-9df8-5a825810e819", "title": "ORA-06592 and the Case of the Happy Australians", "url": "https://mikesmithers.wordpress.com/2018/01/26/ora-06592-and-the-case-of-the-happy-australians/", "published_at": "2018-01-26T20:21:24+00:00" }, { "id": "01a0bbd2-5c70-702b-9df8-5a8259025a4e", "title": "Private Functions and ACCESSIBLE BY Packages in 12c", "url": "https://mikesmithers.wordpress.com/2018/01/15/private-functions-and-accessible-by-packages-in-12c/", "published_at": "2018-01-15T13:48:15+00:00" }, { "id": "01a0bbd2-5c70-702b-9df8-5a8259b6757e", "title": "Cloning around with VirtualBox", "url": "https://mikesmithers.wordpress.com/2017/12/27/cloning-around-with-virtualbox/", "published_at": "2017-12-27T18:54:41+00:00" }, { "id": "01a0bbd2-5c70-702b-9df8-5a825a8126cc", "title": "PLS-00231 – The best laid (cunning) plans and private package functions", "url": "https://mikesmithers.wordpress.com/2017/11/30/pls-00231-the-best-laid-cunning-plans-and-private-package-functions/", "published_at": "2017-11-30T21:02:32+00:00" }, { "id": "01a0bbd6-3dd1-72e7-9d04-4179f6c32e2c", "title": "The Rise of AI – A Cautionary Halloween Tale", "url": "https://mikesmithers.wordpress.com/2017/10/29/the-rise-of-ai-a-cautionary-halloween-tale/", "published_at": "2017-10-29T20:53:56+00:00" }, { "id": "01a0bbd6-3dd1-72e7-9d04-4179f75b5ba6", "title": "Importing an Excel Spreadsheet into an Oracle database with SQLDeveloper", "url": "https://mikesmithers.wordpress.com/2017/10/24/importing-an-excel-spreadsheet-into-an-oracle-database-with-sqldeveloper/", "published_at": "2017-10-24T19:25:48+00:00" }, { "id": "01a0bbd6-3dd1-72e7-9d04-4179f810347a", "title": "In-Line Views versus Correlated Sub-queries – tuning adventures in a Data Warehouse Report", "url": "https://mikesmithers.wordpress.com/2017/09/30/in-line-views-versus-correlated-sub-queries-tuning-adventures-in-a-data-warehouse-report/", "published_at": "2017-09-30T19:22:22+00:00" }, { "id": "01a0bbd6-3dd1-72e7-9d04-4179f819183e", "title": "The March of IDEs – Installing Visual Studio Code on Ubuntu", "url": "https://mikesmithers.wordpress.com/2017/08/28/the-march-of-ides-installing-visual-studio-code-on-ubuntu/", "published_at": "2017-08-28T11:29:21+00:00" }, { "id": "01a0bbd6-3dd1-72e7-9d04-4179f833da76", "title": "REGEXP_LIKE – Happy thoughts whilst searching for multiple substrings in Oracle SQL", "url": "https://mikesmithers.wordpress.com/2017/08/17/regexp_like-happy-thoughts-whilst-searching-for-multiple-substrings-in-oracle-sql/", "published_at": "2017-08-17T20:35:09+00:00" }, { "id": "01a0bbd6-3dd1-72e7-9d04-4179f86d21c6", "title": "Using Edition Based Redefinition for Rolling Back Stored Program Unit Changes", "url": "https://mikesmithers.wordpress.com/2017/08/10/using-edition-based-redefinition-for-rolling-back-stored-program-unit-changes/", "published_at": "2017-08-10T20:14:18+00:00" }, { "id": "01a0bbd6-3dd1-72e7-9d04-4179f896b1a6", "title": "Keyboard not working in Citrix Receiver for Linux – a workaround", "url": "https://mikesmithers.wordpress.com/2017/07/08/keyboard-not-working-in-citrix-receiver-for-linux-a-workaround/", "published_at": "2017-07-08T19:47:06+00:00" }, { "id": "01a0bbd6-3dd1-72e7-9d04-4179f96b5862", "title": "Installing SQLDeveloper and SQLCL on CentOS", "url": "https://mikesmithers.wordpress.com/2017/06/19/installing-sqldeveloper-and-sqlcl-on-centos/", "published_at": "2017-06-19T19:02:25+00:00" }, { "id": "01a0bbd6-3dd1-72e7-9d04-4179fa38a3cf", "title": "Dude, Where’s My File ? Finding External Table Files in the midst of (another) General Election", "url": "https://mikesmithers.wordpress.com/2017/05/22/dude-wheres-my-file-finding-external-table-files-in-the-midst-of-another-general-election/", "published_at": "2017-05-22T21:11:00+00:00" }, { "id": "01a0bbd6-3dd1-72e7-9d04-4179fb0e5b41", "title": "Having a mid-life crisis on top-of-the-range hardware", "url": "https://mikesmithers.wordpress.com/2017/05/08/having-a-mid-life-crisis-on-top-of-the-range-hardware/", "published_at": "2017-05-08T22:31:42+00:00" }, { "id": "01a0bbd9-e7b9-734d-b2bf-e539baf28b86", "title": "Kicking the habit of WM_CONCAT for a delimited list of rows, with LISTAGG", "url": "https://mikesmithers.wordpress.com/2017/05/02/kicking-the-habit-of-wm_concat-for-a-delimited-list-of-rows-with-listagg/", "published_at": "2017-05-02T20:40:38+00:00" }, { "id": "01a0bbd9-e7b9-734d-b2bf-e539bb6890ca", "title": "The Rest of the Django App – the View and Controller Tiers", "url": "https://mikesmithers.wordpress.com/2017/04/21/the-rest-of-the-django-app-the-view-and-controller-tiers/", "published_at": "2017-04-21T20:27:57+00:00" }, { "id": "01a0bbd9-e7b9-734d-b2bf-e539bc652c79", "title": "The Django Fandango Farrago – Looking at Django’s Physical Data Model Design", "url": "https://mikesmithers.wordpress.com/2017/03/15/the-django-fandango-farrago-looking-at-djangos-physical-data-model-design/", "published_at": "2017-03-15T13:40:35+00:00" }, { "id": "01a0bbd9-e7ba-737e-bcd4-bff9c8b47865", "title": "Configuring Django with Apache on a Raspberry Pi", "url": "https://mikesmithers.wordpress.com/2017/02/21/configuring-django-with-apache-on-a-raspberry-pi/", "published_at": "2017-02-21T13:07:42+00:00" }, { "id": "01a0bbd9-e7ba-737e-bcd4-bff9c9aa18f1", "title": "Breaking the Rules – why sometimes it’s OK to have a standalone PL/SQL Function", "url": "https://mikesmithers.wordpress.com/2017/02/06/breaking-the-rules-why-sometimes-its-ok-to-have-a-standalone-plsql-function/", "published_at": "2017-02-06T22:45:31+00:00" }, { "id": "01a0bbd9-e7ba-737e-bcd4-bff9ca31e586", "title": "Automated Testing Frameworks and General Rule-Breaking in PL/SQL", "url": "https://mikesmithers.wordpress.com/2017/01/07/automated-testing-frameworks-and-general-rule-breaking-in-plsql/", "published_at": "2017-01-07T14:58:20+00:00" }, { "id": "01a0bbd9-e7ba-737e-bcd4-bff9ca9bd4ed", "title": "Post-Truth PL/SQL", "url": "https://mikesmithers.wordpress.com/2016/12/09/post-truth-plsql/", "published_at": "2016-12-09T21:19:00+00:00" }, { "id": "01a0bbd9-e7ba-737e-bcd4-bff9cb05d4bc", "title": "Testing Times – using ruby-plsql-spec for testing PL/SQL", "url": "https://mikesmithers.wordpress.com/2016/11/13/testing-times-using-ruby-plsql-spec-for-testing-plsql/", "published_at": "2016-11-13T18:22:32+00:00" }, { "id": "01a0bbd9-e7ba-737e-bcd4-bff9cbc4a37f", "title": "Chasing your tail – with SQL*Plus and SQLcl", "url": "https://mikesmithers.wordpress.com/2016/10/11/chasing-your-tail-with-sqlplus-and-sqlcl/", "published_at": "2016-10-11T21:40:12+00:00" }, { "id": "01a0bbd9-e7ba-737e-bcd4-bff9ccb559e9", "title": "utPLSQL – We’re building the…Unit Tests!", "url": "https://mikesmithers.wordpress.com/2016/09/25/utplsql-were-building-the-unit-tests/", "published_at": "2016-09-25T21:17:32+00:00" }, { "id": "01a0bbdd-9558-7032-b453-269bb212bb53", "title": "(Almost) Everything you ever wanted to know about SQLDeveloper Unit Testing but were afraid to ask", "url": "https://mikesmithers.wordpress.com/2016/08/20/almost-everything-you-ever-wanted-to-know-about-sqldeveloper-unit-testing-but-were-afraid-to-ask/", "published_at": "2016-08-20T20:46:11+00:00" }, { "id": "01a0bbdd-9558-7032-b453-269bb226a935", "title": "Test Driven Development and PL/SQL – The Odyssey Begins", "url": "https://mikesmithers.wordpress.com/2016/07/31/test-driven-development-and-plsql-the-odyssey-begins/", "published_at": "2016-07-31T19:58:02+00:00" }, { "id": "01a0bbdd-9558-7032-b453-269bb302996c", "title": "The Oracle Data Dictionary – Keeping an eye on your application in uncertain times", "url": "https://mikesmithers.wordpress.com/2016/07/17/the-oracle-data-dictionary-keeping-an-eye-on-your-application-in-uncertain-times/", "published_at": "2016-07-17T18:15:25+00:00" }, { "id": "01a0bbdd-9558-7032-b453-269bb3f8e5a5", "title": "Oracle – Pinning table data in the Buffer Cache", "url": "https://mikesmithers.wordpress.com/2016/06/23/oracle-pinning-table-data-in-the-buffer-cache/", "published_at": "2016-06-23T20:13:46+00:00" }, { "id": "01a0bbdd-9558-7032-b453-269bb478e58f", "title": "What’s Special About Oracle ? Relational Databases and the Thick Database Paradigm", "url": "https://mikesmithers.wordpress.com/2016/06/03/whats-special-about-oracle-relational-databases-and-the-thick-database-paradigm/", "published_at": "2016-06-03T14:46:11+00:00" }, { "id": "01a0bbdd-9558-7032-b453-269bb49684c9", "title": "Null is Odd…or Things I Used to Know about SQL Aggregate Functions", "url": "https://mikesmithers.wordpress.com/2016/05/16/null-is-odd-or-things-i-used-to-know-about-sql-aggregate-functions/", "published_at": "2016-05-16T20:03:05+00:00" }, { "id": "01a0bbdd-9558-7032-b453-269bb5367341", "title": "Standard SQL ? – Oracle REGEXP_LIKE", "url": "https://mikesmithers.wordpress.com/2016/04/28/standard-sql-oracle-regexp_like/", "published_at": "2016-04-28T11:55:01+00:00" }, { "id": "01a0bbdd-9558-7032-b453-269bb5b52959", "title": "Getting the current SQL statement from SYS_CONTEXT using Fine Grained Auditing", "url": "https://mikesmithers.wordpress.com/2016/04/17/getting-the-current-sql-statement-from-sys_context-using-fine-grained-auditing/", "published_at": "2016-04-17T19:44:45+00:00" }, { "id": "01a0bbdd-9558-7032-b453-269bb6a4916e", "title": "Adrift in a Data Lake – an Oracle Developer’s first steps in Hadoop", "url": "https://mikesmithers.wordpress.com/2016/03/28/adrift-in-a-data-lake-an-oracle-developers-first-steps-in-hadoop/", "published_at": "2016-03-28T16:49:21+00:00" }, { "id": "01a0bbdd-9558-7032-b453-269bb6fa19c0", "title": "Live to Win – Motorhead Covers and Pythonic Irrigation", "url": "https://mikesmithers.wordpress.com/2016/03/08/live-to-win-motorhead-covers-and-pythonic-irrigation/", "published_at": "2016-03-08T21:31:53+00:00" }, { "id": "01a0bbe1-03da-70c3-b0cb-3f81d4bc4388", "title": "Resolving Hardware Issues with a Kernel Upgrade in Linux Mint", "url": "https://mikesmithers.wordpress.com/2016/02/07/resolving-hardware-issues-with-a-kernel-upgrade-in-linux-mint/", "published_at": "2016-02-07T17:40:34+00:00" }, { "id": "01a0bbe1-03da-70c3-b0cb-3f81d54efdce", "title": "Making Datapump Import Stat-tastically faster", "url": "https://mikesmithers.wordpress.com/2016/01/20/making-datapump-import-stat-tastically-faster/", "published_at": "2016-01-20T20:29:34+00:00" }, { "id": "01a0bbe1-03da-70c3-b0cb-3f81d55983ca", "title": "DBMS_METADATA and SELECT_CATALOG_ROLE – Cat Herding in Oracle", "url": "https://mikesmithers.wordpress.com/2016/01/10/dbms_metadata-and-select_catalog_role-cat-herding-in-oracle/", "published_at": "2016-01-10T17:28:44+00:00" }, { "id": "01a0bbe1-03da-70c3-b0cb-3f81d6401365", "title": "Getting one of your Five-a-Day – connecting Remotely to a Raspberry Pi from Linux Mint", "url": "https://mikesmithers.wordpress.com/2015/12/26/getting-one-of-your-five-a-day-connecting-remotely-to-a-raspberry-pi-from-linux-mint/", "published_at": "2015-12-26T18:42:39+00:00" }, { "id": "01a0bbe1-03da-70c3-b0cb-3f81d6606653", "title": "Stat Wars – using the Force (DBMS_STATS) for Incremental Stats Gathering", "url": "https://mikesmithers.wordpress.com/2015/12/22/stat-wars-using-the-force-dbms_stats-for-incremental-stats-gathering/", "published_at": "2015-12-22T12:03:12+00:00" }, { "id": "01a0bbe1-03da-70c3-b0cb-3f81d6a1a3bb", "title": "A False Sense of Security, or how Database Developers can save £35 million", "url": "https://mikesmithers.wordpress.com/2015/11/29/a-false-sense-of-security-or-how-database-developers-can-save-35-million/", "published_at": "2015-11-29T18:00:38+00:00" }, { "id": "01a0bbe1-03da-70c3-b0cb-3f81d6e79cbb", "title": "Gits and Giggles – Getting onto Github from Mint", "url": "https://mikesmithers.wordpress.com/2015/11/08/gits-and-giggles-getting-onto-github-from-mint/", "published_at": "2015-11-08T14:36:50+00:00" }, { "id": "01a0bbe1-03da-70c3-b0cb-3f81d7516d58", "title": "Reverse Engineering a CRUD Matrix in Oracle (again) – with CRUDO", "url": "https://mikesmithers.wordpress.com/2015/10/20/reverse-engineering-a-crud-matrix-in-oracle-again-with-crudo/", "published_at": "2015-10-20T17:55:14+00:00" }, { "id": "01a0bbe1-03da-70c3-b0cb-3f81d765174b", "title": "User-Defined Context Menus in SQLDeveloper", "url": "https://mikesmithers.wordpress.com/2015/10/05/user-defined-context-menus-in-sqldeveloper/", "published_at": "2015-10-05T11:46:07+00:00" }, { "id": "01a0bbe1-03da-70c3-b0cb-3f81d7ba3f84", "title": "Becoming Unhinged with INSERT ALL and SEQUENCE.NEXTVAL", "url": "https://mikesmithers.wordpress.com/2015/09/20/becoming-unhinged-with-insert-all-and-sequence-nextval/", "published_at": "2015-09-20T19:00:16+00:00" }, { "id": "01a0bbe4-3be2-7183-b8cf-1cb449384bd7", "title": "Caching in – Oracle Sequences and Performance", "url": "https://mikesmithers.wordpress.com/2015/09/04/caching-in-oracle-sequences-and-performance/", "published_at": "2015-09-04T20:00:25+00:00" }, { "id": "01a0bbe4-3be2-7183-b8cf-1cb44a33faaf", "title": "What’s that Skippy ? Mike’s doing too much typing to Instrument his PL/SQL code ?", "url": "https://mikesmithers.wordpress.com/2015/08/15/whats-that-skippy-mikes-doing-too-much-typing-to-instrument-his-plsql-code/", "published_at": "2015-08-15T12:53:58+00:00" }, { "id": "01a0bbe4-3be2-7183-b8cf-1cb44b222a94", "title": "PL/SQL Error Logging and Quantum Theory", "url": "https://mikesmithers.wordpress.com/2015/07/24/plsql-error-logging-and-quantum-theory/", "published_at": "2015-07-24T20:17:31+00:00" }, { "id": "01a0bbe4-3be2-7183-b8cf-1cb44b83cb2e", "title": "Keep your Database Tidy – making sure a file exists before DBMS_DATAPUMP makes a mess", "url": "https://mikesmithers.wordpress.com/2015/07/06/keep-your-database-tidy-making-sure-a-file-exists-before-dbms_datapump-makes-a-mess/", "published_at": "2015-07-06T19:06:26+00:00" }, { "id": "01a0bbe4-3be2-7183-b8cf-1cb44bb2b9e4", "title": "What’s in a Name ? USER_TAB_COLS and USER_TAB_COLUMNS are different.", "url": "https://mikesmithers.wordpress.com/2015/06/23/whats-in-a-name-user_tab_cols-and-user_tab_columns-are-different/", "published_at": "2015-06-23T19:22:06+00:00" }, { "id": "01a0bbe4-3be2-7183-b8cf-1cb44bcfee73", "title": "Upgrading to APEX 5 on Oracle XE 11g", "url": "https://mikesmithers.wordpress.com/2015/05/25/upgrading-to-apex-5-on-oracle-xe-11g/", "published_at": "2015-05-25T13:27:02+00:00" }, { "id": "01a0bbe4-3be2-7183-b8cf-1cb44c06297e", "title": "Migrating the XE Database Management Application to a new version of APEX", "url": "https://mikesmithers.wordpress.com/2015/05/24/migrating-the-xe-database-management-application-to-a-new-version-of-apex/", "published_at": "2015-05-24T14:31:53+00:00" }, { "id": "01a0bbe4-3be2-7183-b8cf-1cb44c72124d", "title": "The Ping of Mild Annoyance Attack and other Linux Adventures", "url": "https://mikesmithers.wordpress.com/2015/05/13/the-ping-of-mild-annoyance-attack-and-other-linux-adventures/", "published_at": "2015-05-13T20:46:49+00:00" }, { "id": "01a0bbe4-3be2-7183-b8cf-1cb44c89ed25", "title": "Oracle XE 11g – Getting APEX to start when your database does", "url": "https://mikesmithers.wordpress.com/2015/05/03/oracle-xe-11g-getting-apex-to-start-when-your-database-does/", "published_at": "2015-05-03T09:53:08+00:00" }, { "id": "01a0bbe4-3be2-7183-b8cf-1cb44cf406e4", "title": "Getting a File Listing from a Directory in PL/SQL", "url": "https://mikesmithers.wordpress.com/2015/04/25/getting-a-file-listing-from-a-directory-in-plsql/", "published_at": "2015-04-25T18:32:41+00:00" }, { "id": "01a0bbe7-7c35-70e3-8aaf-94853eececd2", "title": "SQLCL – The New SQL*Plus", "url": "https://mikesmithers.wordpress.com/2015/04/12/sqlcl-the-new-sqlplus/", "published_at": "2015-04-12T16:33:57+00:00" }, { "id": "01a0bbe7-7c35-70e3-8aaf-94853f1c51b9", "title": "SQLDeveloper XML Extensions and auto-navigation", "url": "https://mikesmithers.wordpress.com/2015/03/22/sqldeveloper-xml-extensions-and-auto-navigation/", "published_at": "2015-03-22T15:42:14+00:00" }, { "id": "01a0bbe7-7c35-70e3-8aaf-94853f9a0500", "title": "Installing Oracle XE on CentOS", "url": "https://mikesmithers.wordpress.com/2015/03/01/installing-oracle-xe-on-centos/", "published_at": "2015-03-01T17:33:18+00:00" }, { "id": "01a0bbe7-7c35-70e3-8aaf-94853fddb5f8", "title": "SQL*Plus Terminator Torture", "url": "https://mikesmithers.wordpress.com/2015/02/26/sqlplus-terminator-torture/", "published_at": "2015-02-26T11:42:50+00:00" }, { "id": "01a0bbe7-7c35-70e3-8aaf-94853febb4f4", "title": "Installing and Configuring an Oracle Developer Day VirtualBox Image", "url": "https://mikesmithers.wordpress.com/2015/01/25/installing-and-configuring-an-oracle-developer-day-virtualbox-image/", "published_at": "2015-01-25T21:28:20+00:00" }, { "id": "01a0bbe7-7c35-70e3-8aaf-948540205b99", "title": "CREATE USER and ALTER USER – changing passwords and a New Year’s Resolution", "url": "https://mikesmithers.wordpress.com/2015/01/11/create-user-and-alter-user-changing-passwords-and-a-new-years-resolution/", "published_at": "2015-01-11T14:39:28+00:00" }, { "id": "01a0bbe7-7c35-70e3-8aaf-94854045a640", "title": "Installing VirtualBox on Mint with a CentOS Guest", "url": "https://mikesmithers.wordpress.com/2014/12/21/installing-virtualbox-on-mint-with-a-centos-guest/", "published_at": "2014-12-21T18:48:45+00:00" }, { "id": "01a0bbe7-7c35-70e3-8aaf-948540d839e9", "title": "Implementing a Database Authentication Scheme in APEX", "url": "https://mikesmithers.wordpress.com/2014/12/14/implementing-a-database-authentication-scheme-in-apex/", "published_at": "2014-12-14T18:26:24+00:00" }, { "id": "01a0bbe7-7c35-70e3-8aaf-948541a59f09", "title": "APEX 503 – Service Unavailable – And you don’t know the APEX_PUBLIC_USER Password", "url": "https://mikesmithers.wordpress.com/2014/12/07/apex-503-service-unavailable-and-you-dont-know-the-apex_public_user-password/", "published_at": "2014-12-07T18:46:44+00:00" }, { "id": "01a0bbe7-7c35-70e3-8aaf-9485425b62df", "title": "Kilobytes, Kibibytes and DBMS_XPLAN undocumented functions", "url": "https://mikesmithers.wordpress.com/2014/12/01/kilobytes-kibibytes-and-dbms_xplan-undocumented-functions/", "published_at": "2014-12-01T18:46:21+00:00" }, { "id": "01a0bbeb-bda6-72b8-93fb-9662ac0f856f", "title": "APEX and Privileges Granted through Roles", "url": "https://mikesmithers.wordpress.com/2014/11/15/apex-and-privileges-granted-through-roles/", "published_at": "2014-11-15T21:33:59+00:00" }, { "id": "01a0bbeb-bda6-72b8-93fb-9662ac473c29", "title": "Going dotty – Generating a Filename containing a parameter value in SQL*Plus", "url": "https://mikesmithers.wordpress.com/2014/10/18/going-dotty-generating-a-filename-containing-a-parameter-value-in-sqlplus/", "published_at": "2014-10-18T18:01:48+00:00" }, { "id": "01a0bbeb-bda6-72b8-93fb-9662acfe3588", "title": "Sayonara to Sequences and Trouble for Triggers – Fun and Games in Oracle 12c", "url": "https://mikesmithers.wordpress.com/2014/09/13/sayonara-to-sequences-and-trouble-for-triggers-fun-and-games-in-oracle-12c/", "published_at": "2014-09-13T14:57:28+00:00" }, { "id": "01a0bbeb-bda6-72b8-93fb-9662ade8ff54", "title": "Getting Python to play with Oracle using cxOracle on Mint and Ubuntu", "url": "https://mikesmithers.wordpress.com/2014/08/25/getting-python-to-play-with-oracle-using-cxoracle-on-mint-and-ubuntu/", "published_at": "2014-08-25T18:57:11+00:00" }, { "id": "01a0bbeb-bda6-72b8-93fb-9662ae6c40a5", "title": "ANSI Joins and Uppercase Keywords – making PL/SQL look less like COBOL", "url": "https://mikesmithers.wordpress.com/2014/07/30/ansi-joins-and-uppercase-keywords-making-plsql-look-less-like-cobol/", "published_at": "2014-07-30T12:12:38+00:00" }, { "id": "01a0bbeb-bda6-72b8-93fb-9662af407840", "title": "DBMS_DATAPUMP – why quote delimiters are your friend", "url": "https://mikesmithers.wordpress.com/2014/06/30/dbms_datapump-why-quote-delimiters-are-your-friend/", "published_at": "2014-06-30T11:06:44+00:00" }, { "id": "01a0bbeb-bda6-72b8-93fb-9662b001f7b5", "title": "Oracle’s hidden documentation – Commenting the Data Model in Oracle", "url": "https://mikesmithers.wordpress.com/2014/06/08/oracles-hidden-documentation-commenting-the-data-model-in-oracle/", "published_at": "2014-06-08T12:55:15+00:00" }, { "id": "01a0bbeb-bda6-72b8-93fb-9662b0e05cd2", "title": "Putting the Plus into SQL*Plus – describing a Package member (with added kittens)", "url": "https://mikesmithers.wordpress.com/2014/05/31/putting-the-plus-into-sqlplus-describing-a-package-member-with-added-kittens/", "published_at": "2014-05-31T16:05:41+00:00" }, { "id": "01a0bbeb-bda6-72b8-93fb-9662b154ac30", "title": "Long to CLOB conversion – Constraint Conditions and Database D.I.Y", "url": "https://mikesmithers.wordpress.com/2014/05/20/long-to-clob-conversion-constraint-conditions-and-database-d-i-y/", "published_at": "2014-05-20T17:50:10+00:00" }, { "id": "01a0bbeb-bda6-72b8-93fb-9662b1d39d55", "title": "Tracing for fun and (tk)profit", "url": "https://mikesmithers.wordpress.com/2014/05/06/tracing-for-fun-and-tkprofit/", "published_at": "2014-05-06T20:55:28+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

2019

Extending the range of my Home Network Wi-fi by converting an old router into a Wireless Access Pointoriginal ↗
2 Sept 2019
Changing the Hostname and IP Address on a CentOS server and re-configuring Oracle and ORDSoriginal ↗
13 Aug 2019
VirtualBox – running a Windows 10 Guest on an Ubuntu Hostoriginal ↗
2 Aug 2019
Customizing DML in an APEX Interactive Gridoriginal ↗
23 Jul 2019
Oracle Express Edition – features new to 18cXEoriginal ↗
13 Jul 2019
SQLcl ALIAS – because you can’t remember everything.original ↗
25 Jun 2019
Installing the OE demo schema on 18cXEoriginal ↗
15 Jun 2019
Great Football Managers and Oracle Unified Auditingoriginal ↗
31 May 2019
ORA-01775 – Looping Chain of Synonyms and Epic Football Punditryoriginal ↗
30 Apr 2019
Easy Listening with Datapump in the SQLDeveloper DBA Moduleoriginal ↗
1 Apr 2019
Adding an item to the Ubuntu Unity Launcheroriginal ↗
24 Mar 2019
Installing APEX and ORDS on Oracle 18cXE on CentOSoriginal ↗
1 Mar 2019
Oracle Create Schema – multiple DDL statements in a single transactionoriginal ↗
14 Feb 2019
Pi in a time of Brexit – Remote Controlling Raspberry Pi from Ubuntu using VNCoriginal ↗
27 Jan 2019
Using a Proxy User for Code Deployment in Oracleoriginal ↗
14 Jan 2019
Installing and Configuring Oracle 18cXE on CentOSoriginal ↗
3 Jan 2019

2018

Debbie Saves Christmas – Database Development in a Devops Wonderland : Re-runnable DDLoriginal ↗
19 Dec 2018
VirtualBox – configuring a Host-Only Networkoriginal ↗
17 Nov 2018
New Dog, Old Tricks – how to save yourself some typing with sedoriginal ↗
4 Nov 2018
Cocktails and Traffic Cones – party time with DVDs and Blu-Rays in Ubuntuoriginal ↗
29 Aug 2018
Read Only Access for providing backend support for an Oracle Applicationoriginal ↗
25 Jul 2018
You have chosen not to trust… – Citrix Receiver and SSL error 61 on Ubuntuoriginal ↗
8 Jun 2018
First Steps in SQLDeveloper Data Modeleroriginal ↗
30 May 2018
utPLSQL 3.0 – How to have your cake and eat itoriginal ↗
25 Apr 2018
Streaming Videos with Plex on Raspberry Pioriginal ↗
8 Apr 2018
Geeky Speed Freakery in the Wild (South) West…original ↗
25 Feb 2018
ORA-06592 and the Case of the Happy Australiansoriginal ↗
26 Jan 2018
Private Functions and ACCESSIBLE BY Packages in 12coriginal ↗
15 Jan 2018

2017

Cloning around with VirtualBoxoriginal ↗
27 Dec 2017
PLS-00231 – The best laid (cunning) plans and private package functionsoriginal ↗
30 Nov 2017
The Rise of AI – A Cautionary Halloween Taleoriginal ↗
29 Oct 2017
Importing an Excel Spreadsheet into an Oracle database with SQLDeveloperoriginal ↗
24 Oct 2017
In-Line Views versus Correlated Sub-queries – tuning adventures in a Data Warehouse Reportoriginal ↗
30 Sept 2017
The March of IDEs – Installing Visual Studio Code on Ubuntuoriginal ↗
28 Aug 2017
REGEXP_LIKE – Happy thoughts whilst searching for multiple substrings in Oracle SQLoriginal ↗
17 Aug 2017
Using Edition Based Redefinition for Rolling Back Stored Program Unit Changesoriginal ↗
10 Aug 2017
Keyboard not working in Citrix Receiver for Linux – a workaroundoriginal ↗
8 Jul 2017
Installing SQLDeveloper and SQLCL on CentOSoriginal ↗
19 Jun 2017
Dude, Where’s My File ? Finding External Table Files in the midst of (another) General Electionoriginal ↗
22 May 2017
Having a mid-life crisis on top-of-the-range hardwareoriginal ↗
8 May 2017
Kicking the habit of WM_CONCAT for a delimited list of rows, with LISTAGGoriginal ↗
2 May 2017
The Rest of the Django App – the View and Controller Tiersoriginal ↗
21 Apr 2017
The Django Fandango Farrago – Looking at Django’s Physical Data Model Designoriginal ↗
15 Mar 2017
Configuring Django with Apache on a Raspberry Pioriginal ↗
21 Feb 2017
Breaking the Rules – why sometimes it’s OK to have a standalone PL/SQL Functionoriginal ↗
6 Feb 2017
Automated Testing Frameworks and General Rule-Breaking in PL/SQLoriginal ↗
7 Jan 2017

2016

Post-Truth PL/SQLoriginal ↗
9 Dec 2016
Testing Times – using ruby-plsql-spec for testing PL/SQLoriginal ↗
13 Nov 2016
Chasing your tail – with SQL*Plus and SQLcloriginal ↗
11 Oct 2016
utPLSQL – We’re building the…Unit Tests!original ↗
25 Sept 2016
(Almost) Everything you ever wanted to know about SQLDeveloper Unit Testing but were afraid to askoriginal ↗
20 Aug 2016
Test Driven Development and PL/SQL – The Odyssey Beginsoriginal ↗
31 Jul 2016
The Oracle Data Dictionary – Keeping an eye on your application in uncertain timesoriginal ↗
17 Jul 2016
Oracle – Pinning table data in the Buffer Cacheoriginal ↗
23 Jun 2016
What’s Special About Oracle ? Relational Databases and the Thick Database Paradigmoriginal ↗
3 Jun 2016
Null is Odd…or Things I Used to Know about SQL Aggregate Functionsoriginal ↗
16 May 2016
Standard SQL ? – Oracle REGEXP_LIKEoriginal ↗
28 Apr 2016
Getting the current SQL statement from SYS_CONTEXT using Fine Grained Auditingoriginal ↗
17 Apr 2016
Adrift in a Data Lake – an Oracle Developer’s first steps in Hadooporiginal ↗
28 Mar 2016
Live to Win – Motorhead Covers and Pythonic Irrigationoriginal ↗
8 Mar 2016
Resolving Hardware Issues with a Kernel Upgrade in Linux Mintoriginal ↗
7 Feb 2016
Making Datapump Import Stat-tastically fasteroriginal ↗
20 Jan 2016
DBMS_METADATA and SELECT_CATALOG_ROLE – Cat Herding in Oracleoriginal ↗
10 Jan 2016

2015

Getting one of your Five-a-Day – connecting Remotely to a Raspberry Pi from Linux Mintoriginal ↗
26 Dec 2015
Stat Wars – using the Force (DBMS_STATS) for Incremental Stats Gatheringoriginal ↗
22 Dec 2015
A False Sense of Security, or how Database Developers can save £35 millionoriginal ↗
29 Nov 2015
Gits and Giggles – Getting onto Github from Mintoriginal ↗
8 Nov 2015
Reverse Engineering a CRUD Matrix in Oracle (again) – with CRUDOoriginal ↗
20 Oct 2015
User-Defined Context Menus in SQLDeveloperoriginal ↗
5 Oct 2015
Becoming Unhinged with INSERT ALL and SEQUENCE.NEXTVALoriginal ↗
20 Sept 2015
Caching in – Oracle Sequences and Performanceoriginal ↗
4 Sept 2015
What’s that Skippy ? Mike’s doing too much typing to Instrument his PL/SQL code ?original ↗
15 Aug 2015
PL/SQL Error Logging and Quantum Theoryoriginal ↗
24 Jul 2015
Keep your Database Tidy – making sure a file exists before DBMS_DATAPUMP makes a messoriginal ↗
6 Jul 2015
What’s in a Name ? USER_TAB_COLS and USER_TAB_COLUMNS are different.original ↗
23 Jun 2015
Upgrading to APEX 5 on Oracle XE 11goriginal ↗
25 May 2015
Migrating the XE Database Management Application to a new version of APEXoriginal ↗
24 May 2015
The Ping of Mild Annoyance Attack and other Linux Adventuresoriginal ↗
13 May 2015
Oracle XE 11g – Getting APEX to start when your database doesoriginal ↗
3 May 2015
Getting a File Listing from a Directory in PL/SQLoriginal ↗
25 Apr 2015
SQLCL – The New SQL*Plusoriginal ↗
12 Apr 2015
SQLDeveloper XML Extensions and auto-navigationoriginal ↗
22 Mar 2015
Installing Oracle XE on CentOSoriginal ↗
1 Mar 2015
SQL*Plus Terminator Tortureoriginal ↗
26 Feb 2015
Installing and Configuring an Oracle Developer Day VirtualBox Imageoriginal ↗
25 Jan 2015
CREATE USER and ALTER USER – changing passwords and a New Year’s Resolutionoriginal ↗
11 Jan 2015

2014

Installing VirtualBox on Mint with a CentOS Guestoriginal ↗
21 Dec 2014
Implementing a Database Authentication Scheme in APEXoriginal ↗
14 Dec 2014
APEX 503 – Service Unavailable – And you don’t know the APEX_PUBLIC_USER Passwordoriginal ↗
7 Dec 2014
Kilobytes, Kibibytes and DBMS_XPLAN undocumented functionsoriginal ↗
1 Dec 2014
APEX and Privileges Granted through Rolesoriginal ↗
15 Nov 2014
Going dotty – Generating a Filename containing a parameter value in SQL*Plusoriginal ↗
18 Oct 2014
Sayonara to Sequences and Trouble for Triggers – Fun and Games in Oracle 12coriginal ↗
13 Sept 2014
Getting Python to play with Oracle using cxOracle on Mint and Ubuntuoriginal ↗
25 Aug 2014
ANSI Joins and Uppercase Keywords – making PL/SQL look less like COBOLoriginal ↗
30 Jul 2014
DBMS_DATAPUMP – why quote delimiters are your friendoriginal ↗
30 Jun 2014
Oracle’s hidden documentation – Commenting the Data Model in Oracleoriginal ↗
8 Jun 2014
Putting the Plus into SQL*Plus – describing a Package member (with added kittens)original ↗
31 May 2014
Long to CLOB conversion – Constraint Conditions and Database D.I.Yoriginal ↗
20 May 2014
Tracing for fun and (tk)profitoriginal ↗
6 May 2014
Previous Next