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
SQL Plus 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... -
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...