-
Follow me on Twitter
- @MikeMc68 they should be banned, same as the people who stand in the exit rather than stepping off, blocking people from getting offSeptember 3, 2010 12:31
- My hearing is still fecked from riding the Deaf Machine 3 days ago... its a stupid deathtrap of a bike but very very fun...September 3, 2010 8:24
- built a bridge rectifier for my AC generatorSeptember 2, 2010 9:24
- @mike_1727 with a pint of ale in each hand, progressively lightening themSeptember 2, 2010 8:09
- Just ran another 7km - 2 days in a row... will switch routines and exercise down the pub tomorrowSeptember 2, 2010 7:54
SQL Plus Archive
-
Oracle: Delete all rows from all tables etc…
Posted on April 13, 2010 | No CommentsQuick method to do multiple actions across multiple tables. Simply spool a script with your commands in for each table – this way you can avoid dropping your tables or user and still keep all your schema structure. So for instance to delete all data... -
Writing basic case switch statements in Oracle PL/SQL
Posted on July 28, 2009 | No CommentsThis is the equivalent code for writing a switch statement in Oracle. In Oracle to do the switch we use a function called case. Which looks for a value in the field specified, when it returns true it returns a value else returns a default.... -
Spool a CSV file from Oracle/ SQL*Plus without quotes
Posted on July 17, 2009 | 4 CommentsQuite useful, I had the case where I needed to provide a CSV file to an external party from our Oracle 10g database. No problem, there are loads of CSV export tools out there. But it then transpired that the CSV’s that I was generating...