-
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
Oracle 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... -
Oracle: Update From equivalent
Posted on March 22, 2010 | No CommentsQuick note on how to update data in a series of joined tables using a subquery in the UPDATE statement in Oracle, kind of like the UPDATE FROM in SqlServer. First of all check out the above diagram, I’ve stolen it from this link: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/update_statement.htm... -
Changing the HTTP port Oracle uses
Posted on December 12, 2009 | No CommentsIn a production environment your database server will be completely separate from your application server or at least it should be. So in theory you should never really need to change this setting unless its for your development environment. In my case I needed to... -
Setting Database Connections in JBoss/ ATG
Posted on December 12, 2009 | No CommentsATG communicates to a database via JBoss via a dynamo server setup or in your home/localconfig directory if you’re not using specific dynamo servers. In this setup you specify the JNDI connection name which will then refer to an XML file which makes up part... -
Joining columns/ concatenate strings in Oracle PLSQL/ MySQL
Posted on August 7, 2009 | 1 CommentJoining columns and results together is really easy in Oracle or MySQL, in both there is the same function – CONCAT(). However you should be aware that there are differences between the databases on how this function works. In MySQL the CONCAT() function works by... -
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... -
LIMIT equivalent for Oracle
Posted on June 3, 2009 | No CommentsSo you use MySQL etc… and you’re used to adding a LIMIT clause to your query for example, SELECT * FROM table WHERE name = ‘bob’ LIMIT 1 And now you’re using Oracle and want to do the same thing? But it throws some dread...