Tags
AJAX Arduino ATG concatenation Control a DC motor DC motor Distance sensor generator GP2Y0A02 H-Bridge Infrared IR Javascript JBoss jboss 4.0.5.GA L293D Motorcycle motors Music MySQL Oracle Perl Photoshop PHP PL/SQL Potentiometer Processing Projects Radar Robot Arm Serial port Servo Sharp SN754410 Sonar SQL SQL Plus SRF05 Triple Tutorial Ultrasound Visualise Sensor Data XML XS750 Yamaha-
Latest Tweets
- Spreading King Diamond around the office, expecting face paint at work tomorrow.February 16, 2012 11:13
- The worst song ever: http://t.co/jLZGs8cE by Rancid. I lasted only 47 seconds before I wanted to cut my ears offFebruary 16, 2012 11:12
- Download festival is for pussiesFebruary 15, 2012 12:30
- http://t.co/l81GWkBN Hellfest? hell yes!February 15, 2012 12:30
- So Whitney Houston died? Let the music industry mourn with a few 'new' best of compilations preferably with some crappy demos on thereFebruary 13, 2012 5:12
Oracle Archive
-
Oracle: Delete all rows from all tables etc…
Posted on April 13, 2010 | 1 CommentQuick 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... -
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.... -
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... -
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... -
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... -
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... -
Spool a CSV file from Oracle/ SQL*Plus without quotes
Posted on July 17, 2009 | 10 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... -
LIMIT equivalent for Oracle
Posted on June 3, 2009 | 1 CommentSo 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...