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
- @kuntandthegang Turns out you can print anything on your train ticket if you know how: http://t.co/FQQ3U6OdMay 7, 2012 9:35
- Pretty sure I just broke our datawarehouse. I just told it that silicon heaven doesn't exist.May 1, 2012 10:53
- @toddhalfpenny my house!, I may have a tmp sensor kicking about. I'll have a look. Otherwise the internet is your friendApril 28, 2012 7:01
- @zenilorac Already got tickets!April 28, 2012 7:01
- "trying to lock himself in a bag... An expert said he and his assistant tried to do it 300 times without success." should have talked to meApril 27, 2012 1:25
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 | 11 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...