41554 blogs · [ { "id": "01a0bc0b-200a-73dd-a8bb-c8eed8b95246", "title": "Getting output from Ref Cursors in PL/SQL", "url": "https://mikesmithers.wordpress.com/2010/09/13/getting-output-from-ref-cursors-in-plsql/", "published_at": "2010-09-13T20:59:55+00:00" }, { "id": "01a0bc0b-200a-73dd-a8bb-c8eed8eaedb3", "title": "Windows Bashing…with Cygwin", "url": "https://mikesmithers.wordpress.com/2010/08/30/windows-bashing-with-cygwin/", "published_at": "2010-08-30T21:41:09+00:00" }, { "id": "01a0bc0b-200a-73dd-a8bb-c8eed9a4f3be", "title": "Triggers on Views in SQLDeveloper", "url": "https://mikesmithers.wordpress.com/2010/08/26/triggers-on-views-in-sqldeveloper/", "published_at": "2010-08-26T11:40:48+00:00" }, { "id": "01a0bc0b-200a-73dd-a8bb-c8eeda6d6b28", "title": "Unable to See Package Bodies in SQLDeveloper 2.1.1", "url": "https://mikesmithers.wordpress.com/2010/08/06/unable-to-see-package-bodies-in-sqldeveloper-2-1-1/", "published_at": "2010-08-06T19:08:08+00:00" }, { "id": "01a0bc0b-200a-73dd-a8bb-c8eeda8da9b5", "title": "Oracle Client on Ubuntu – Installation and Configuration", "url": "https://mikesmithers.wordpress.com/2010/08/02/oracle-client-on-ubuntu-%e2%80%93-installation-and-configuration/", "published_at": "2010-08-02T21:03:21+00:00" }, { "id": "01a0bc0b-200a-73dd-a8bb-c8eedae8f5ce", "title": "DMBS_OUTPUT Can’t Count – Or When is 32767 not 32767 ?", "url": "https://mikesmithers.wordpress.com/2010/07/24/dmbs_output-cant-count-%e2%80%93-or-when-is-32767-not-32767/", "published_at": "2010-07-24T15:58:01+00:00" }, { "id": "01a0bc0b-200a-73dd-a8bb-c8eedbd65a1b", "title": "Definitely the final post about CASE – things that make you go Doh !", "url": "https://mikesmithers.wordpress.com/2010/07/22/definitely-the-final-post-about-case-%e2%80%93-things-that-make-you-go-doh/", "published_at": "2010-07-22T18:58:42+00:00" }, { "id": "01a0bc0b-200a-73dd-a8bb-c8eedc3d1401", "title": "Going Postal – Validating UK Postcode format in PL/SQL", "url": "https://mikesmithers.wordpress.com/2010/07/15/going-postal-%e2%80%93-validating-uk-postcode-format-in-plsql/", "published_at": "2010-07-15T22:43:58+00:00" }, { "id": "01a0bc0b-200a-73dd-a8bb-c8eedd170d96", "title": "Basket Case – CASE statement in SQL", "url": "https://mikesmithers.wordpress.com/2010/07/12/basket-case-%e2%80%93-case-statement-in-sql/", "published_at": "2010-07-12T21:24:27+00:00" }, { "id": "01a0bc0b-200a-73dd-a8bb-c8eedd573a72", "title": "More Nefarious Nullable Nonsense – Coalesce", "url": "https://mikesmithers.wordpress.com/2010/07/08/more-nefarious-nullable-nonsense-%e2%80%93-coalesce/", "published_at": "2010-07-08T21:57:35+00:00" }, { "id": "01a0bc0d-79a5-709f-853e-6478b5c1f1fb", "title": "Taking the bind out of mid-tier queries", "url": "https://mikesmithers.wordpress.com/2010/07/03/taking-the-bind-out-of-mid-tier-queries/", "published_at": "2010-07-03T17:32:51+00:00" }, { "id": "01a0bc0d-79a5-709f-853e-6478b608ba1a", "title": "Gullible about Nullable – Stuff I thought I knew…and didn’t", "url": "https://mikesmithers.wordpress.com/2010/06/21/gullible-about-nullable-%e2%80%93-stuff-i-thought-i-knew-and-didnt/", "published_at": "2010-06-21T22:49:52+00:00" }, { "id": "01a0bc0d-79a5-709f-853e-6478b68d65f8", "title": "Getting the Quiz Machine to Pay Out – talking to your database from a shell script", "url": "https://mikesmithers.wordpress.com/2010/06/15/getting-the-quiz-machine-to-pay-out-%e2%80%93-talking-to-your-database-from-a-shell-script/", "published_at": "2010-06-15T22:53:09+00:00" }, { "id": "01a0bc0d-79a5-709f-853e-6478b6c21356", "title": "Triggers are bad m’kay – more Mutant Madness", "url": "https://mikesmithers.wordpress.com/2010/06/09/triggers-are-bad-mkay-%e2%80%93-more-mutant-madness/", "published_at": "2010-06-09T17:18:55+00:00" }, { "id": "01a0bc0d-79a5-709f-853e-6478b6d19909", "title": "Mostly Painless – Upgrading to Ubuntu 10.04", "url": "https://mikesmithers.wordpress.com/2010/05/23/mostly-painless-upgrading-to-ubuntu-10-04/", "published_at": "2010-05-23T17:21:28+00:00" }, { "id": "01a0bc0d-79a5-709f-853e-6478b7619cee", "title": "Passing parameters in SQL*Plus – or What’s the opposite of a Chick Flick ?", "url": "https://mikesmithers.wordpress.com/2010/05/17/passing-parameters-in-sqlplus-%e2%80%93-or-whats-the-opposite-of-a-chick-flick/", "published_at": "2010-05-17T00:12:13+00:00" }, { "id": "01a0bc0d-79a5-709f-853e-6478b7c86649", "title": "Caching in – adventures in Oracle Tuning", "url": "https://mikesmithers.wordpress.com/2010/05/09/caching-in-%e2%80%93-adventures-in-oracle-tuning/", "published_at": "2010-05-09T17:11:34+00:00" }, { "id": "01a0bc0d-79a5-709f-853e-6478b7de01d7", "title": "Compound Triggers – Managing the Mutant Menace", "url": "https://mikesmithers.wordpress.com/2010/04/24/compound-triggers-%e2%80%93-managing-the-mutant-menace/", "published_at": "2010-04-24T16:21:14+00:00" }, { "id": "01a0bc0d-79a5-709f-853e-6478b7e3173d", "title": "Troubleshooting Oracle 10g XE Installation on Ubuntu", "url": "https://mikesmithers.wordpress.com/2010/04/05/troubleshooting-oracle-10g-xe-installation-on-ubuntu/", "published_at": "2010-04-05T14:37:11+00:00" }, { "id": "01a0bc0d-79a5-709f-853e-6478b87f0194", "title": "Express Yourself – String Comparison in Oracle using REGEXP_REPLACE", "url": "https://mikesmithers.wordpress.com/2010/03/29/express-yourself-%e2%80%93-string-comparison-in-oracle-using-regexp_replace/", "published_at": "2010-03-29T16:47:14+00:00" }, { "id": "01a0bc0f-b88c-7342-914c-dd35ea2b4964", "title": "Installing Oracle 11gR2 on Ubuntu 9.10", "url": "https://mikesmithers.wordpress.com/2010/03/14/installing-oracle-11gr2-on-ubuntu-9-10/", "published_at": "2010-03-14T19:46:26+00:00" }, { "id": "01a0bc0f-b88d-72e0-9b2b-b286a92e2aee", "title": "Tunneling X over SSH on Ubuntu 9.10", "url": "https://mikesmithers.wordpress.com/2010/03/08/tunnelling-x-over-ssh-on-ubuntu-9-10/", "published_at": "2010-03-08T19:23:24+00:00" }, { "id": "01a0bc0f-b88d-72e0-9b2b-b286a93c0032", "title": "Essaying a sashay with Samba", "url": "https://mikesmithers.wordpress.com/2010/03/04/essaying-a-sashay-with-samba/", "published_at": "2010-03-04T13:38:05+00:00" }, { "id": "01a0bc0f-b88d-72e0-9b2b-b286aa370112", "title": "Installing Ubuntu Server and SSH setup", "url": "https://mikesmithers.wordpress.com/2010/03/03/installing-ubuntu-server-and-ssh-setup/", "published_at": "2010-03-03T13:34:01+00:00" }, { "id": "01a0bc0f-b88d-72e0-9b2b-b286aaa0d96b", "title": "PL/SQL Syntax Highlighting in Textpad – for when you can’t play with Penguins", "url": "https://mikesmithers.wordpress.com/2010/02/23/plsql-syntax-highlighting-in-textpad-for-when-you-cant-play-with-penguins/", "published_at": "2010-02-23T23:25:25+00:00" }, { "id": "01a0bc0f-b88d-72e0-9b2b-b286ab1eff15", "title": "Dropping quoted users – why sometimes Oracle can’t bear to say goodbye", "url": "https://mikesmithers.wordpress.com/2010/02/17/dropping-quoted-users-%e2%80%93-why-sometimes-oracle-cant-bear-to-say-goodbye/", "published_at": "2010-02-17T23:52:28+00:00" }, { "id": "01a0bc0f-b88d-72e0-9b2b-b286abd95cc5", "title": "Self-Inflicted SQL Injection – don’t quote me !", "url": "https://mikesmithers.wordpress.com/2010/02/11/self-inflicted-sql-injection-%e2%80%93-dont-quote-me/", "published_at": "2010-02-11T21:21:24+00:00" }, { "id": "01a0bc0f-b88d-72e0-9b2b-b286ac604a92", "title": "Return in a PL/SQL Procedure – Just one more thing Mum never told me", "url": "https://mikesmithers.wordpress.com/2010/02/10/return-in-a-plsql-procedure-%e2%80%93-just-one-more-thing-mum-never-told-me/", "published_at": "2010-02-10T01:22:16+00:00" }, { "id": "01a0bc0f-b88d-72e0-9b2b-b286ac9b5cd4", "title": "Escaping quotes without ruining your eyesight", "url": "https://mikesmithers.wordpress.com/2010/01/30/escaping-quotes-without-ruining-your-eyesight/", "published_at": "2010-01-30T02:15:34+00:00" }, { "id": "01a0bc0f-b88d-72e0-9b2b-b286ad511dc6", "title": "Customising gedit for PL/SQL on Ubuntu 9.10", "url": "https://mikesmithers.wordpress.com/2010/01/27/customising-gedit-for-plsql-on-ubuntu-9-10/", "published_at": "2010-01-27T21:54:09+00:00" }, { "id": "01a0bc11-f16d-736e-a349-fff19ab52da2", "title": "Reverse-Engineering a CRUD Matrix in Oracle", "url": "https://mikesmithers.wordpress.com/2010/01/17/reverse-engineering-a-crud-matrix-in-oracle/", "published_at": "2010-01-17T17:17:21+00:00" }, { "id": "01a0bc11-f16d-736e-a349-fff19b8c333e", "title": "Why setting Default Tablespace on the Database affects some Oracle Internal Users", "url": "https://mikesmithers.wordpress.com/2010/01/10/why-setting-default-tablespace-on-the-database-affects-some-oracle-internal-users/", "published_at": "2010-01-10T23:40:58+00:00" }, { "id": "01a0bc11-f16d-736e-a349-fff19c2ac73d", "title": "Slave Driving – Getting SQL*Plus to do it for you", "url": "https://mikesmithers.wordpress.com/2010/01/09/slave-driving-getting-sqlplus-to-do-it-for-you/", "published_at": "2010-01-09T01:56:42+00:00" }, { "id": "01a0bc11-f16d-736e-a349-fff19c4d7a80", "title": "Solved – The Mystery of SQLDeveloper and the Missing ocijdbc11", "url": "https://mikesmithers.wordpress.com/2010/01/03/solved-%e2%80%93-the-mystery-of-sqldeveloper-and-the-missing-ocijdbc11/", "published_at": "2010-01-03T15:07:39+00:00" }, { "id": "01a0bc11-f16d-736e-a349-fff19ce05bf3", "title": "Playtime…watching DVDs on Ubuntu 9.10", "url": "https://mikesmithers.wordpress.com/2009/12/27/playtime-watching-dvds-on-ubuntu-9-10/", "published_at": "2009-12-27T15:43:03+00:00" }, { "id": "01a0bc11-f16d-736e-a349-fff19d8aa41d", "title": "Too many declarations of “+” match this call – When Compilers lie", "url": "https://mikesmithers.wordpress.com/2009/12/23/too-many-declarations-of-%e2%80%9c%e2%80%9d-match-this-call-%e2%80%93-when-compilers-lie/", "published_at": "2009-12-23T23:34:33+00:00" }, { "id": "01a0bc11-f16d-736e-a349-fff19e62b37f", "title": "SQLDeveloper doesn’t like Mondays – refusing to play with TNS defined connection", "url": "https://mikesmithers.wordpress.com/2009/12/17/sqldeveloper-doesnt-like-mondays-%e2%80%93-refusing-to-play-with-tns-defined-connection/", "published_at": "2009-12-17T00:52:32+00:00" }, { "id": "01a0bc11-f16d-736e-a349-fff19f468a05", "title": "Installing SQLDeveloper 1.5.5 on Ubuntu 9.10", "url": "https://mikesmithers.wordpress.com/2009/12/14/installing-sqldeveloper-1-5-5-on-ubuntu-9-10/", "published_at": "2009-12-14T21:52:16+00:00" }, { "id": "01a0bc11-f16d-736e-a349-fff1a001e0e5", "title": "Installing Oracle XE on Ubuntu 9.10", "url": "https://mikesmithers.wordpress.com/2009/12/07/installing-oracle-xe-on-ubuntu-9-10/", "published_at": "2009-12-07T21:51:56+00:00" }, { "id": "01a0bc11-f16d-736e-a349-fff1a02e5791", "title": "Adding your own tabs in SQLDeveloper", "url": "https://mikesmithers.wordpress.com/2009/12/05/adding-your-own-tabs-in-sqldeveloper/", "published_at": "2009-12-05T21:08:54+00:00" }, { "id": "01a0bc14-2fcb-72e6-b863-4646cd511c00", "title": "SQLDeveloper or TOAD", "url": "https://mikesmithers.wordpress.com/2009/12/04/sqldeveloper-or-toad/", "published_at": "2009-12-03T23:56:29+00:00" }, { "id": "01a0bc14-2fcb-72e6-b863-4646ce453389", "title": "Axiom – a framework for sanity in Software Development", "url": "https://mikesmithers.wordpress.com/2009/12/01/axiom-%e2%80%93-a-framework-for-sanity-in-software-development/", "published_at": "2009-12-01T22:10:41+00:00" }, { "id": "01a0bc14-2fcb-72e6-b863-4646cf0f5cae", "title": "Ubuntu 9.10 – On the slippery slope to hardcore geekdom", "url": "https://mikesmithers.wordpress.com/2009/12/01/ubuntu-9-10-%e2%80%93-on-the-slippery-slope-to-hardcore-geekdom/", "published_at": "2009-12-01T00:22:25+00:00" }, { "id": "01a0bc14-2fcb-72e6-b863-4646cfdb2738", "title": "Sociable PL/SQL – associative arrays indexed by VARCHAR2", "url": "https://mikesmithers.wordpress.com/2009/10/05/sociable-plsql-%e2%80%93-associative-arrays-indexed-by-varchar2/", "published_at": "2009-10-05T20:48:14+00:00" }, { "id": "01a0bc14-2fcb-72e6-b863-4646cff5a3dd", "title": "Des Cartes Must Die – a Killer App for PL/SQL", "url": "https://mikesmithers.wordpress.com/2009/08/31/des-cartes-must-die-%e2%80%93-a-killer-app-for-plsql/", "published_at": "2009-08-31T23:03:03+00:00" }, { "id": "01a0bc14-2fcb-72e6-b863-4646d0c95a68", "title": "The computer has forgotten my password !", "url": "https://mikesmithers.wordpress.com/2009/08/12/the-computer-has-forgotten-my-password/", "published_at": "2009-08-12T19:40:08+00:00" }, { "id": "01a0bc14-2fcb-72e6-b863-4646d0d0c46b", "title": "Oerr Missus – Carry On find that error", "url": "https://mikesmithers.wordpress.com/2009/07/21/oerr-missus-carry-on-find-that-error/", "published_at": "2009-07-21T22:37:52+00:00" }, { "id": "01a0bc14-2fcb-72e6-b863-4646d0f7de21", "title": "Clock watching – Instrumenting PL/SQL with timing information", "url": "https://mikesmithers.wordpress.com/2009/06/30/clock-watching-%e2%80%93-instrumenting-plsql-with-timing-information/", "published_at": "2009-06-30T21:32:34+00:00" }, { "id": "01a0bc14-2fcb-72e6-b863-4646d16c6a12", "title": "Lazy Insert", "url": "https://mikesmithers.wordpress.com/2009/06/09/lazy-insert/", "published_at": "2009-06-09T21:03:34+00:00" }, { "id": "01a0bc14-2fcb-72e6-b863-4646d1d7b3ef", "title": "You Don’t Have to be Posh to be Privileged", "url": "https://mikesmithers.wordpress.com/2009/06/06/you-dont-have-to-be-posh-to-be-privileged/", "published_at": "2009-06-06T13:31:43+00:00" }, { "id": "01a0bc16-81bf-71bf-99db-75a74e4d8b6b", "title": "CONTINUE statement in PL/SQL – or how GOTO can be a useful member of society", "url": "https://mikesmithers.wordpress.com/2009/05/18/continue-statement-in-plsql-%e2%80%93-or-how-goto-can-be-a-useful-member-of-society/", "published_at": "2009-05-18T11:52:52+00:00" }, { "id": "01a0bc16-81bf-71bf-99db-75a74f36d09b", "title": "Simple is good – an ISNUMBER Function for PL/SQL", "url": "https://mikesmithers.wordpress.com/2009/05/09/isnumber-function-for-plsql/", "published_at": "2009-05-09T16:22:18+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

2010

Getting output from Ref Cursors in PL/SQL original ↗

13 Sept 2010

Windows Bashing…with Cygwin original ↗

30 Aug 2010

Triggers on Views in SQLDeveloper original ↗

26 Aug 2010

Unable to See Package Bodies in SQLDeveloper 2.1.1 original ↗

6 Aug 2010

Oracle Client on Ubuntu – Installation and Configuration original ↗

2 Aug 2010

DMBS_OUTPUT Can’t Count – Or When is 32767 not 32767 ?original ↗

24 Jul 2010

Definitely the final post about CASE – things that make you go Doh !original ↗

22 Jul 2010

Going Postal – Validating UK Postcode format in PL/SQL original ↗

15 Jul 2010

Basket Case – CASE statement in SQL original ↗

12 Jul 2010

More Nefarious Nullable Nonsense – Coalesce original ↗

8 Jul 2010

Taking the bind out of mid-tier queries original ↗

3 Jul 2010

Gullible about Nullable – Stuff I thought I knew…and didn’t original ↗

21 Jun 2010

Getting the Quiz Machine to Pay Out – talking to your database from a shell script original ↗

15 Jun 2010

Triggers are bad m’kay – more Mutant Madness original ↗

9 Jun 2010

Mostly Painless – Upgrading to Ubuntu 10.04 original ↗

23 May 2010

Passing parameters in SQL*Plus – or What’s the opposite of a Chick Flick ?original ↗

17 May 2010

Caching in – adventures in Oracle Tuning original ↗

9 May 2010

Compound Triggers – Managing the Mutant Menace original ↗

24 Apr 2010

Troubleshooting Oracle 10g XE Installation on Ubuntu original ↗

5 Apr 2010

Express Yourself – String Comparison in Oracle using REGEXP_REPLACE original ↗

29 Mar 2010

Installing Oracle 11gR2 on Ubuntu 9.10 original ↗

14 Mar 2010

Tunneling X over SSH on Ubuntu 9.10 original ↗

8 Mar 2010

Essaying a sashay with Samba original ↗

4 Mar 2010

Installing Ubuntu Server and SSH setup original ↗

3 Mar 2010

PL/SQL Syntax Highlighting in Textpad – for when you can’t play with Penguins original ↗

23 Feb 2010

Dropping quoted users – why sometimes Oracle can’t bear to say goodbye original ↗

17 Feb 2010

Self-Inflicted SQL Injection – don’t quote me !original ↗

11 Feb 2010

Return in a PL/SQL Procedure – Just one more thing Mum never told me original ↗

10 Feb 2010

Escaping quotes without ruining your eyesight original ↗

30 Jan 2010

Customising gedit for PL/SQL on Ubuntu 9.10 original ↗

27 Jan 2010

Reverse-Engineering a CRUD Matrix in Oracle original ↗

17 Jan 2010

Why setting Default Tablespace on the Database affects some Oracle Internal Users original ↗

10 Jan 2010

Slave Driving – Getting SQL*Plus to do it for you original ↗

9 Jan 2010

Solved – The Mystery of SQLDeveloper and the Missing ocijdbc11 original ↗

3 Jan 2010

2009

Playtime…watching DVDs on Ubuntu 9.10 original ↗

27 Dec 2009

Too many declarations of “+” match this call – When Compilers lie original ↗

23 Dec 2009

SQLDeveloper doesn’t like Mondays – refusing to play with TNS defined connection original ↗

17 Dec 2009

Installing SQLDeveloper 1.5.5 on Ubuntu 9.10 original ↗

14 Dec 2009

Installing Oracle XE on Ubuntu 9.10 original ↗

7 Dec 2009

Adding your own tabs in SQLDeveloper original ↗

5 Dec 2009

SQLDeveloper or TOAD original ↗

3 Dec 2009

Axiom – a framework for sanity in Software Development original ↗

1 Dec 2009

Ubuntu 9.10 – On the slippery slope to hardcore geekdom original ↗

1 Dec 2009

Sociable PL/SQL – associative arrays indexed by VARCHAR2 original ↗

5 Oct 2009

Des Cartes Must Die – a Killer App for PL/SQL original ↗

31 Aug 2009

The computer has forgotten my password !original ↗

12 Aug 2009

Oerr Missus – Carry On find that error original ↗

21 Jul 2009

Clock watching – Instrumenting PL/SQL with timing information original ↗

30 Jun 2009

Lazy Insert original ↗

9 Jun 2009

You Don’t Have to be Posh to be Privileged original ↗

6 Jun 2009

CONTINUE statement in PL/SQL – or how GOTO can be a useful member of society original ↗

18 May 2009

Simple is good – an ISNUMBER Function for PL/SQL original ↗

9 May 2009